Re: Emergency help needed with oracle insert!!!

["Ranade, Sameer" <sranade@BRISHOSP.CHIME.ORG>]

Hi,

        This happened to me once. And the prblem was I'd
deleted/inserted/updated some rows from the same table in another SQLplus
session and did not commit. If you have not commited any operations in any
other open session,commit them and try running SQR again !

HTH,
-Sameer

-----Original Message-----
From: Buchanan, Timothy [mailto:buchanan@BIPERF.COM]
Sent: Wednesday, January 27, 1999 1:48 PM
To: Multiple recipients of list SQR-USERS
Subject: Emergency help needed with oracle insert!!!


Howdy,

Much thanks is given in advance...

I am trying to insert data into an oracle table. here is my bare-bones sqr:

#include 'setenv.sqc'
begin-program
display 'Step#1'
begin-sql
on-error=insert-error
insert into PS_PYMNT_WTHD_BOOK
(BUSINESS_UNIT, VOUCHER_ID, PYMNT_CNT, VOUCHER_LINE_NUM , WTHD_ENTITY,
WTHD_TYPE, WTHD_CLASS, LEDGER_GROUP , LEDGER , BASE_CURRENCY ,
CUR_RT_TYPE_PYMNT , PYMNT_RATE_MULT, PYMNT_RATE_DIV , WTHD_BASIS_AMT_BSE,
WTHD_AMT_BSE, PRIMARY_LEDGER , PROCESS_INSTANCE)
values
('BIPER', '00077815', 1, 1, 'IRS', '1099', '07', 'ACTUALS', 'ACTUALS',
'USD', 'CRRNT', 1.0, 1.0, 123.45, 123.45, 'Y', 5555)
end-sql
display 'Step #2'
end-program
begin-procedure insert-error
display 'error'
STOP
end-procedure


When I run it, it does not get past "Step #1", and freezes up. I can run
other SQR's that insert data into other tables, no problem. Their syntax is
the exact same as mine. I can cut and paste the SQL above into SQL+ and run
it with no problem, it inserts the data. HELP! I am losing my mind! Thanks
again

Timm Buchanan