Re: 2 newbie OCI questions

Maybe I'm on the right track: I found a function OCINumberToInt() for converting the Oracle NUMBER type to native format. (I'm running on NT.) It doesn't want to compile however, because the compiler wants to see the prototype as ANSI C style; however other header files have problems compiling this way; they prefer to be compiled as K&R.

Geez... There's gotta be an easier way!

In article <7flfsh$s6a$1_at_nnrp1.dejanews.com>,   dgallardo_at_my-dejanews.com wrote:
> Hi everyone -
>
> I'll start with my general question: where can I get doc for the Oracle call
> interface? I have the doc from Oracle, but I'm finding it hard starting out.
> I've used code from the examples, but am still having problems understanding
> exactly what's going on. None of the Oracle books I've seen, including the
> otherwise fine "ORACLE8, The Complete Reference", have anything about OCI.
> Also, the pointer to the OCI wrapper that someone provided seems to be dead.
> Arggghhh....
>
> So on to my second question: Am I on the right track? I'm having various
> problems trying to process dynamically generated SQL. My code allocates the
> handles it needs (per code I borrowed from cdemo81.c). I don't do a bind,
> because I'm not using any bind variables. I prepare the statement & get the
> statement handle, call OCIStmtExec(), then use a sequence of OCIParamGet() and
> OCIAttrGet() calls to get the number of columns, the column names, and the
> datatypes. So far, so good. Then I call OCIDefineByPos() for each column,
> using the datatypes I got from before. Finally, I call OCIStmtExec() again
> (with iterations set to 1, next few params set to 0, and mode set to
> OCI_DEFAULT). This is supposed to fill in all the addresses I specified with
> the define, right?
>
> This all seems to go OK except for the following problems:
>
> 1. I don't get all the column names. The last few are null. (The db looks
> ok when I use the same SQL statement in SQL*PLUS.)
>
> 2. Char buffers look OK but when I get an int back, it's not what I expect
> (or at least, in the encoding I expect. E.g. instead of 1 I get 0x2c1, 2 is
> 0x3c1, 100 is 0x2c2, 255 is 0x3803c2. What's up with that? Do I need
to
> somehow specify the encoding type I want for ints?)
>
> 3. I don't get all the column values for the row. I get an access violation
> trying to access past the third or fourth column.
>
> And finally--how do I get the next row? If I call OCIStmtExec() again, I get
> the same row back.
>
> Thanks in advance for any help & apologies if this is all in a FAQ someplace
> (I looked but didn't find...)
>
> - David
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 22 1999 - 15:56:54 CDT