PL/SQL on UNIX AIX

Shell Programming and Scripting
1

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

2

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

3

Hello Jim,

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

Thanks

Rahul