From: Johan den Boer <jj.den.boer@hccnet.nl>
Subject: PRO C/C++ Last Sql Statement
Date: 2000/04/29
Message-ID: <390A77F8.E8FB1934@hccnet.nl>#1/1
Content-Transfer-Encoding: 7bit
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
X-Complaints-To: abuse@hccnet.nl
X-Trace: news.hccnet.nl 956987356 12734 193.173.112.5 (29 Apr 2000 05:49:16 GMT)
Organization: Hobby Computer Club News Network
Mime-Version: 1.0
NNTP-Posting-Date: 29 Apr 2000 05:49:16 GMT
Newsgroups: comp.databases.oracle.tools


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@hccnet.nl