Re: Starting Pro*c program

sgundu wrote:
>
> Hi All,
> I had a pro*c program that uses DBMS_PIPES to send email form database. This program works fine and sends an email. The
> database shuts down at night to run backups. Whenver the database shutdown, this program is getting terminated, so i have to
> start this program manually. Instead of that i decided to set a cron job that starts this program automatically at 6:00 AM.
> I don't know for some reason cron is unable to start this program. I don't know why? Looks like i need to start this program
> manually after each database shutdown. Anybody can tell me a soution for this problem?
>
> sree

You are probably lacking some environmental variables like ORACLE_SID and ORACLE_HOME which are probably being set when you log in to an interactive session.

AFAIK, never run anything except shell scripts from the cron. That way you can take care of initializations in a shell script which then invokes your program.

Do you have thorough error checking in your program? If so, what errors are you seeing?

Also, consider modifying the shell script pointed to by S99oracle (or the equivalent on your machine) and gracefully shutting down your program rather than allowing it to be killed when Oracle goes down. Received on Mon Nov 01 1999 - 15:01:24 CST