Re: calls to SQL -Reply

[Allan Geetter <geetter@UHAVAX.HARTFORD.EDU>]

I also update Oracle from SQR.  I assume some additional code is missing
from your example.  It might help to post the actual code.

Allan Geetter
University of Hartford

Andrew Campbell wrote:

> 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


begin:          vcard
fn:             Allan  Geetter
n:              Geetter;Allan
org:            University of Hartford
adr;dom:        200 Bloomfield Ave.;;Information Technology Services - CC125;West Hartford;Connecticut;06117-1599;
email;internet: geetter@uhavax.hartford.edu
title:          Data Security Administrator
tel;work:       (860) 768-4889
tel;fax:        (860) 768-4907
x-mozilla-cpt:  ;0
x-mozilla-html: TRUE
version:        2.1
end:            vcard