"ORACLE LOGON PROCEDURE"

[AMIT]

Hi,

Could some one send me the example of "LOGON PROCEDURE" for connecting
to particular Oracle database among various oracle databases.

Thanks.

Amit

[Frank van Bortel]

AMIT wrote:
Hi, Could some one send me the example of "LOGON PROCEDURE" for connecting to particular Oracle database among various oracle databases. Thanks. Amit

Using what? SQLPlus user/password@alias (sqlplus being an executable)
--

Regards,
Frank van Bortel

[Daniel Morgan]

AMIT wrote: Hi, Could some one send me the example of "LOGON PROCEDURE" for connecting to particular Oracle database among various oracle databases. Thanks. Amit

Or assuming Oracle Forms:

LOGOUT;
LOGON('app_user_id','app_password'||'@'||'host_name');

With a little imagination you can obfuscate this information in the .FMX.

--
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

[Hans Forbrich]

AMIT wrote:
Hi, Could some one send me the example of "LOGON PROCEDURE" for connecting to particular Oracle database among various oracle databases.

Your question is somewhat vague - there are literally dozens of possible
answers depending on what you are trying to do and what environment (tool,
database, operating system) you are trying to use.

You might want to look at the 'paint by numbers' kit available at
http://otn.oracle.com/obe.start/index.html to help get you started. It
shows some of the simpler mechanisms.

However, based on the way you ask the question, I strongly advise you read
the 'Concepts' manual to get a better understanding of the possibilities.
The manual (for the version you are using) is available at
http://docs.oracle.com