Re: parsing in Oracle8+

Hussam,

There is no equivalent call in Oracle8. The OCIStmtPrepare() method is the closest comparison but not exactly the same. Oracle8 OCI does not have an explicit parse step and the OCIStmtPrepare() method is strictly a local call. OCI7 also implicitly executed DDL statements on the oparse but in Oracle8 all DDL and DML statements are processed on the execute.

I can think of some ways that you may be able to do what you want but none would do so without performing a round-trip to the database and therefore probably would not be worth the effort in the end anyway.

hth,

Cliff

"Hussam Khateeb" <hussam_at_camelot.com> wrote in message news:94f7mn$elg$1_at_news.netvision.net.il...
> Hi;
> In Oracle7 i could use the OCI OPARSE (API) to parse a query (with the
> NO_DEFER option) to get errors before execution on the server.
> What API in Oracle8 is equal to that one (OPARSE) of Oracle7?
> How can i get (syntactic and semantic) errors before execution of a query
 in
> Oracle8?
>
> Thanks in advance
> Hussam
>
>
Received on Thu Jan 25 2001 - 00:46:30 CET