5

sqlplus update issue

view full story
linux-howto

http://www.unix.com – Hi all, I'm facing a problem with a query in a shell script (AIX). Code: sqlplus -s NAME/PASS@SCHEMA<<EOF set echo off UPDATE HISTORY SET HISTORY.ID = (SELECT OFFER.ID FROM OFFER WHERE HISTORY.ID=TO_NUMBER(OFFER.CODE)) WHERE EXISTS (SELECT OFFER.ID FROM OFFER WHERE HISTORY.ID=TO_NUMBER(OFFER.CODE)); commit; exit; EOF I have no answer after that. I try to type exit; but it does nothing like if sqlplus was "thinking". When I try this query directly in Oracle, it works fine. Through a sql script I have the same problem. Could you please help me ? Thanks in advance. Dee (HowTos)