Re: PROC and OCI Beginner's Questions
Date: Thu, 20 Jan 94 10:39:19 GMT
Message-ID: <1994Jan20.103919.20816_at_metagen.co.uk>
In article <1994Jan19.092745.12420_at_janix.pcs.dec.com>, egerton_at_pcs.dec.com (Jim Egerton Digital-PCS GmbH) writes:
|>
|>
|> Hello,
|>
|> I'm new to Oracle and have a few questions regarding the use of
|> PROC and OCI:
|>
|> 1) Is there an embedded DISCONNECT? If not, can the OCI ologof be used
|> instead?
Yup. You use either
EXEC SQL COMMIT [WORK] RELEASE;
or
EXEC SQL ROLLBACK [WORK] RELEASE; The [WORK] is optional. Dont use ologof. If you need to combine OCI and embedded SQL, then there is an OCI call to get access to the login, but you MUST always login using embedded calls to allow the PRO*C libraries to initialize properly.
Hope this helps,
Simon Stearn
(not even worth 1/2p, and only my opinion...)
Received on Thu Jan 20 1994 - 11:39:19 CET