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

[Val W. Harris]

Fred James wrote:

> Now the facts:
> (1) Run mail_utl.sh from the command line, and it all works fine.
> (2) Let the PL/SQL call mail_utl.sh through the C function and it
>     (a) writes all the files correctly.
>     (b) doesn't send the mail.
>
> Any clues would be appreciated.  This same general problem has been
> plaguing me all along - whatever I write works fine until I backup and
> start it all with the PL/SQL procedure - no error messages or codes,
> it just doesn't happen.
>
>
> _______________________________________________
> https://ntlug.org/mailman/listinfo/discuss
>
I would suspect that the user who "runs" the whole shebang through
PL/SQL has a different environment from the user who is testing
the individual parts.  Check the mailx invocation, since everything
seems OK up to that point.

Val

-- 
Val W. Harris              vwharris at airmail.net

"If you have tried to do something but couldn't,
you are far better off than if you tried to do
nothing and succeeded" - John T. Ragland, Jr.