Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> OCI - placeholders and BIND to INSERT & SELECT
Hello
Im using OCI to access ORACLE database from a c program.
Im using INSERT and SELECT of the same columns in the table.
Both INSERT and SELECT use placeholders.
My questions are :
1)Does any placeholder need to use the OCIBind ?
2)If the INSERT and SELECT use the same placeholder (e.g.
:ename) does ename has to do the OCIBind twice for the
INSERT and for the SELECT ?
3)What OCIBind has to be used - OCIBindByPos() or
OCIBindByName ?
4)What is the Bind input / Bind output ? what is their
usage ? Is it neccessary to use them and How do I use
them.
Please give me a full answer whith an example.
Thank you.
uri
Received on Mon Apr 12 1999 - 11:47:59 CDT