Sunday 18 August 2013

Connecting to the Database

At the beginning of Pro*C program, more precisely, the execution of embedded SQL or PL/SQL
statements, one has to connect to the database using a valid Oracle account and password.
Connecting to the database occurs trough the embedded SQL statement
EXEC SQL CONNECT : IDENTIFIED BY :.
Both and are host variables of the type VARCHAR and must be specified and handled respectively.
and can be specified in the Pro*C program, but can also be entered at program runtime using, e.g., the C function scanf.

No comments:

Post a Comment