Shell Programming and Scripting

Hello All,

I have a problem in a ksh script in UNIX AIX machine which is using a PL/SQL block.

I tired to execute the following pl/sql block in a ksh script in UNIX AIX machine.

i donot see any syntax error or other problems but this pl/sql block is working fine in linux, why the same pl/sql block is not working for UNIX AIX machine. iam using AIX 5.3

sqlplus -s /nolog <<EOF
whenever sqlerror exit failure
connect $User/$Pwd@$DBName
SET FEEDBACK OFF;
SET TERMOUT OFF;
SET ECHO OFF;
BEGIN
DBMS_LOCK.SLEEP(160);
END;
/
exit
EOF

Please let me know if anyboby know the resoultion to this issue.
Thanks

Rahul

What error are you getting?
What shell are you running the command under?

Hello Jim,

It just gives the following message "Connected.: not found." .

Thanks

Rahul