Re: dynamic queries under oci

As a FORMER OCI developer my suggestion would be to forgot OCI and use Java instead. Java will free you from every single question you asked in this message. Mind you this isn't a religious, I like Java better than C, I still use C when necessary but for database interaction Java / JDBC is easier to use, introduces fewer complications, and in Oracle 8i is IN the database. You can build SQL on the fly via Prepared Statements and process any data type you want. Also all the memory management hassles of C are null and void. In addition the resources for JDBC and Java with or without Oracle are plentiful, as opposed to OCI which are sparse at best. If OCI is the only way you can go I suggest the Oracle Technical network (otn.oracle.com) which has the best source of OCI info I have found to date.

HTH RHC
Ben Newman wrote:
>
>
> Can someone help me understand the steps that need to be taken executing
> dynamic sql under OCI?
>
> Specifically, suppose I want to execute "select * from foo" where I have
 no
> prior information about the select list. Suppose also that there are no
> user-defined types: they are all guaranteed to be number, character or
 date
> data.
>
> Do I need to use callbacks? Is it true that I can simply prepare and
 execute
> the query without allocating storage beforehand? Who is responsible for
> freeing memory that an OCI call allocates?
>
> Perhaps someone can reccommend a book on the subject: I can't seem to get
> anywhere with the documentation Oracle provides.
>
> --b
>
>

--
Posted via CNET Help.com
http://www.help.com/