PRO C/C++ Last Sql Statement
From: Johan den Boer <jj.den.boer_at_hccnet.nl>
Date: 2000/04/29
Message-ID: <390A77F8.E8FB1934_at_hccnet.nl>#1/1
from my_table
from my_table
Date: 2000/04/29
Message-ID: <390A77F8.E8FB1934_at_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 CEST