Re: Stored procedure and UNIX-shell scripts: not a good combination?

Patrick Smits wrote:

> I've experienced several times now that a stored procedure does not finish
> when started from a AIX UNIX shell-script
> (UNIX shell-script starts sqlplus on UNIX, calling a stored as below:
>
> sqlplus [userid]/[password]_at_[instance] <[...] 2>[...]
> exec [procedure]
> exec [other procedure]
> EOF
>

 You should try;
 sqlplus [userid]/[password]_at_[instance] <[...] 2>[...]  my_procedure('parameter1','parameter2');  other_procedure;

 As far as I know exec is for embedded sql...

regards Kari

(Mr.) Kari Pannila

      Oracle DBA (OCP)
      TietoEnator Corp, Finland

-- 

PS. Delete X from my mail address , it (X) is only for SPAMMERS.
    Poista X mail-osoitteen edestä, se on SPAMmereita varten.