Re: OCI Example?
Date: Mon, 15 Mar 1993 16:08:16 GMT
Message-ID: <1993Mar15.160816.1623_at_cvgis.prime.com>
On a related point,
With ORACLE V7, there does not seem to be an example of a program which
mixes both Pro*C and OCI calls.
This is more of a problem since ORACLE didn't ship me the
Pro*C and OCI manuals with this (Beta) release and coding OCI using
sqllda() as described in the V6 OCI manuals doesn't seem to work.
The V6 OCI manual suggests that something like this will work:
...
struct lda_def lda1;
...
EXEC SQL CONNECT :connect_string;
...
sqllda( & lda1 );
...
At which point the lda1 structure can be used to do normal OCI
operations such as oopen() or osql3().
This is very attractive since as pointed out previously dynamic SQL
cursor management is somewhat awkward in Pro*C.
Does anyone know why the above doesn't work in V7 ? Did it even work in V6 ? Can someone send me sample source ?
-- --------------------------------------------------------- Al Parker, P.Eng, Sr S/W Eng - Computervision GIS 45 Vogell Road, 7th Floor | al_at_cvgis.prime.com Richmond Hill, Ont, CANADA, L4B 3P6 | (416)508-8020(x881)Received on Mon Mar 15 1993 - 17:08:16 CET