Re: Urgent : OCI Gurus : Please Help . . .

In Oracle7, you need to explicitly parse a SQL statement before you can execute it. (I assume that you are running in defered mode)

In Oracle8, OCI programs no longer need to parse a SQL statement explicitly. If a statement must be parsed, the step takes place on execute.

szhan_at_csclub.uwaterloo.ca wrote:

> Jet, you also mentioned about parse the statement. Why? The OCI
> guide for Oracle 8 never mentioned about that.
>
> 2) Parse the above SQL:
> oparse(hstmt, sql_smt, strlen(sql_stmt), 1, 2);
> (I am assuming that you are using defered mode)
> 3) Bind the arguments(input/output) to your host variables: obndra 4)
> Assign the values to the inputs (i.e. host variables)
>
> Philip
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Received on Thu Jul 15 1999 - 14:00:25 CDT