Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Doubt about odesc OCI function
Hi all.
My problem is the following:
I have a sentence like this
INSERT INTO TABLE_1 ( FIELD1, FIELD2, ... ) VALUES( :FIELD1, :FIELD2, ... )
This sentence a class to allow execute Prepared Statement. The Prepared
Statements
are generated dinamically, so i don't know anything about the fields.
The problem comes because the obndrv function, needs to know the size of the
field and i dont know it.
I can obtain the size with the function odescr, but this function needs
that, previously, the obndrv function
has been called. This is what i have to do:
oopen
oparse
for each column
obndrv ( i dont know the size of the field, i put 0, for example ) odescr // now i know the size of the field.end for
and again
oparse
for earch column
obndrv ( now, telling the field size to the function ) end for
This is what i suppose that i have to do after read the OCI Programmer's guide.
Is this Right?
If it is, there is any other easiest way to do it?
I hope that i have explained cleared the problem.
regards Received on Mon Jun 28 1999 - 05:52:42 CDT