Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Doubt about odesc OCI function

Doubt about odesc OCI function

From: Antonio Pascual <apa_at_jerez.micro.lucent.com>
Date: Mon, 28 Jun 1999 12:52:42 +0200
Message-ID: <7l7ka4$5pj@nntpb.cb.lucent.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US