Re: dynamic sql with Pro*C/WinNT 4.0

Thank you very much! An extensive example like this is exactly what I need to get my app working.

On Fri, 11 Apr 1997, Thomas Kyte wrote:
>
> Your missing the allocation of lots of memory for the descriptor. You
> must allocate one, allocate space for each of the output variables,
> decide what datatype you want results in and so on.
>
> I'm attaching an example. 2 of the functions referenced by this
> sample are not included. 'die' simply logs an error and exits.
> Get_Arglist( bind_variable_name ) is used to return a value for a
> given name (i had parsed a URL and had an array of VALUE=VARIABLE
> pairs. Get_Arglist("foo") would return the value for 'foo'.)
>
> Anyway, This piece of code will accept an arbitrary string, could be a
> pl/sql block , insert/update/delete, select whatever. It prepares it,
> binds any inputs for it, executes it and
>
> - if it was Pl/sql, it 'gets the page' from the database. This is
> used with the Oracle Web Server pl/sql toolkit.
>
> - if it was a select statement, it prints it out in various formats.
>
>
> Hope this helps...
[snip] Received on Mon Apr 14 1997 - 00:00:00 CEST