UNIX for Dummies Questions & Answers

I have a question regarding how to connect to Oracle Database through shell script.

1. If I want call a stored procedure on Linux server as this, it works.

Code:

$sqlplus /nolog

SQL*Plus: Release 12.1.0.2.0 Production on Fri Jun 12 14:49:49 2015

Copyright (c) 1982, 2014, Oracle.  All rights reserved.

SQL> connect sysuser/password@SID as sysdba
Connected.
SQL> @tab_call.sql
     /

PL/SQL procedure successfully completed.

2. However, if I create a shell script to connect to database. It seems not connect and call stored procedure.
It didn't fetch any error message. My shell script like this:

Code:

#!/bin/ksh

sqlplus -s  /nolog <<EOF
connect sysuser/password@$SID as sysdba

@tab_call.sql

EOF
exit;

Please advise your comments. where is the problem and how to fix it. Thanks.

Put a / in your shell script after the sql or inside the sql file (which you did from command line, but not from script)

Inside should be more standard,PL/SQL should have :

Code:

END;
/

at the end.

Regards
Peasant.