Newbie question

[Dave Hedgehog]

Hope somebody can help me out with this....

We have a EDI package which uses an Oracle 8 database.
I have been asked to write an PL/SQL stored procedure to access this
database & extract some information
for reporting purposes (possibly using UTL_FILE ?).
I don't have a problem writing & executing any SQL through SQL*PLUS in
windows but how would I go about
executing the stored procedure in a live environment through a UNIX
automated script ? Is this possible ?
Thanks in advance for any help.
Keith

--
---------------------ANTI SPAM -------------------
Please remove myteeth before replying

[Sandra Fraune]

Hi,

if I understand you right, you will execute sqlplus-commands automated
by a unix-script, perhaps with the help of crontab.

Okay, because the 'cron' do not enter the /etc/profile or .profile
you had to put the environment parameter on top of your script.
Now, to execute sqlplus in a shellscript enter:

sqlplus /@{ORACLE_SID}<<-EOF
#here you can enter your sql-statements#

EOF

If you will not connect as / you had to create an OPS$-account.

May this help?

Sandra Fraune

In article <8908r8$aub$1...@tilde.csc.ti.com>,

Sent via Deja.com http://www.deja.com/
Before you buy.

[Doug Cowles]

Another option is not to use cron but to use the dbms_job package to
let Oracle schedule the activity..

On Wed, 23 Feb 2000 13:11:15 GMT, Sandra Fraune <san...@muenster.com>
wrote:

[Dave Hedgehog]

Sandra, Doug,

Thank you both for your replies.

Regards,
Keith

--
---------------------ANTI SPAM -------------------
Please remove myteeth before replying

Doug Cowles <dco...@i84.net> wrote in message
news:38b881e4...@news.remarq.com...

[DNP]

When will the next series on BBC2 be anyway?