I use:

sqlplus USERNAME/PASSWORD@sid <<EOF
exec pr$ocedure;
EOF

or

sqlplus USERNAME/PASSWORD@sid <<EOF
begin
pr$ocedure;
end;
/
EOF


gives as result:

Excuting script.. sending output to mylogdir

BEGIN pr; END;


(or in the first case:

BEGIN pr; END;
*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'PR' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored



((Our procedures in Oracle are named pr$....))

Is seems that is isnt' working??

Anybody any idea what's going wrong/ what I'm missing??

In any unix (including linux), $ in the shell expands what makes what follows as a variablle. (Equivalent to % in DOS bach file).

So, in your case, pr$ocedure become pr<value of ocedure>, ie jusr pr, since ocedure is undefined.

So you have to "escape" the $ by enclosing it in single quotes. The single quote makes everything inside it be a literal.

So your scripts would become.

sqlplus USERNAME/PASSWORD@sid <<EOF
exec 'pr$ocedure';
EOF

or

sqlplus USERNAME/PASSWORD@sid <<EOF
begin
'pr$ocedure';
end;
/
EOF

Please try this and give feedback.

@AnanthaP,
Thx for you answer.

I thought I already tried your suggestion, nevertheless I've tried it again just now.
It didn't work.

The code is now:

begin
'pr$ocedure';
end;


The result is:


BEGIN 'pr'; END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00103: Encountered the symbol "pr" when expecting one of the following:
begin case declare exit for goto if loop mod null pragma
raise return select update while with <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall merge pipe
The symbol "return" was substituted for "pr" to continue.




By the way: The distro is RHEL 4.x

try this:

sqlplus USERNAME/PASSWORD@sid <<EOF
exec pr\$ocedure;
EOF

You do need to escape the $, but use a backslash instead of single quotes.