Re: odescr before bind using OCI

In <1994Sep21.152127.16240_at_abalon.se>, larsj_at_abalon.se (Lars Jonsson) writes:
>In the Programmer's Guide to the OCI it says "if you have placeholders
>for bind variables in a SELECT statement ... you should do the bind
>operation before the describe.".
>
>What happens if I don't? All I really want to know is the internal
>datatype code. I haven't got access to Oracle yet so I can't test
>this myself.
>

Well,
  What this means is you have to bind the input variables before you describe the output variables. So, in the select statement:

select name from number_and_name where number = :number;

you have to bind the ":number" placeholder before you do a describe to get the type/length/etc. of "name". Hope that helps....

  Chad

--
Chad Brockman            | 
VertiComp, Inc           | I'm just an OS/2 Junkie!!
chadb_at_NeoSoft.com        | "Come on kid, it's cheap!!"