[NTLUG:Discuss] C OK, sh OK, but it still doesn't seem to work

[kbrannen@gte.net]

Fred James wrote:
> As a mind jogger, the situation is this:
> (1) A PL/SQL procedure calls a C external procedure (function) that 
> calls a sh script, which finally calls mailx.
...
> sprintf(mailCmd, "/apps/oracle/local/lib/mail_utl.sh '%s' '%s' '%s' '%s' 
> '%s'\n", pSubject, pRecipientList, pMessage, pAttach, pReturnAddress);
> system(mailCmd);
...

In addition to the other useful suggestions made by others, I would also 
suggest you read the Oracle manuals.  I seem to recall other people saying 
they had problems when trying to call outside programs from in a PL/SQL 
program, because the Oracle libs change the environment in unexpected ways. 
The Oracle manuals should tell you how to deal with this.

HTH,
Kevin