Re: Pro*C question (how to get the function type)

From: Scott Urman <surman_at_wwsun10.us.oracle.com>
Date: 8 Oct 1994 20:01:15 GMT
Message-ID: <376tqb$s66_at_dcsun4.us.oracle.com>


In article <3741sf$23i_at_euas20.eua.ericsson.se>, tobias_at_erix.ericsson.se (Tobias Lindgren) writes:
|> When using OCI (Oracle Call Interfaces), the SQL function type is
|> returned in cda.ft after a call to oparse(). Is it possible to get the
|> same information when using Embedded SQL in C (Pro*C), e.g. in the
|> SQLCA?
|>
|> Thanx.
|>

With 1.5 and earlier of the precompilers, the only way to get the current SQL statement is by using the ORACA. With Pro*C 2.0 (and I believe 1.6 as well) there is a function sqlgls() that will return the entire SQL statement (or at least as much of it as you want) as well as the function code. Received on Sat Oct 08 1994 - 21:01:15 CET

Original text of this message