calls to SQL -Reply

[Andrew Campbell <acampbell@UNITEDMEDIA.COM>]

I use Oracle 7.1 and have no problems. Try using on-error to see if your
statement has an error...

>>> Murray Leckie <MLeckie@SIERRASYS.COM> 01/21/98 05:47pm >>>
I was wondering if anybody has ever had any problems making an SQL
update to an oracle database (version 7) with SQR (version 3).  I am
getting my variables back in a display and the select is working okay
however the program is hanging after the select at the call to SQL.  If
I do the command through SQL without the variables, I have no problems.

begin-procedure Update-ITM-VENDOR
display $vend_id
display $Inv_ITEM_ID

begin-select
a.vendor_id,
a.inv_item_id
from ps_itm_vendor a
where a.inv_item_id = $inv_item_id
end-select

display 'working so far'

begin-sql
update PS_ITM_VENDOR
set vendor_id = $vend_id
where inv_item_id = $Inv_item_id
end-sql


R. Murray Leckie
mleckie@sierrasys.com
Telephone: (902) 425-6688
Fax: (902) 425-6689