Hello.
Im using ORACLE as my DB (version 4.0.5) with OAS (4.0.7) on Sun Solaris
2.6.
I try to execute within a c cartridge a communication with the DB.
I try to execute these three stmt : UPDATE , SELECT and INSERT .
Each of them is used for some tables.
This is the process for each stmt:
1)Declaring the stmt : for example "SELECT a , b ,c FROM conn WHERE
d=:myd"
2)Initialuze the stmthp with OCIHandleInitialize()
3)OCIStmtPrepare()
4)OCIDefineByPos() - for the SELECT stmt.
5)OCIBindByName() - for the INSERT/UPDATE/WHERE clause of SELECT
6)OCIStmtExecute()
7)OCIStmtHandleFree()
This of course without the usual things.
1)Do I miss something?
2)Is that enough for executing the statements?
3) Is there anything specific for one of the Statements?
If someone have an example implementing this statements I'll thank him.
Thank you all
Uri
e-mail uri_at_trans-planet.com
Received on Sun May 02 1999 - 20:43:22 CDT
