PROC C/C++ Get Last SQL Statement

From: Johan den Boer <jj.den.boer_at_hccnet.nl>
Date: 2000/04/29
Message-ID: <390A77C8.75AC7531@hccnet.nl>#1/1

Hi,

Suppose I have the following sql statement in a C program :

select field1,

       field2,
       field3
into   :f_hostvar1,


       :f_hostvar2,

       :f_hostvar3   

from my_table

I can get the sql statement in some error function with the sqlgls function ( if you set oraca and the right values for logging )

The fetched sql statement with sqlgls looks like this

select field1,

       field2,
       field3
into   :b1,


       :b2,

       :b3   

from my_table

Oracle changed the hostvariable f_hostvar1 to b1. Is it possible to get the value of the host variable b1, so you can print out the sql statement and the values in the logfile and inform the user to look in the logfile.

regards

Johan den Boer
email : jj.den.boer_at_hccnet.nl Received on Sat Apr 29 2000 - 00:00:00 CDT