asked on

Call UNIX C-Shell Scripts from Oracle sqlplus/stored procedures(!!)

Hi Good person,

I have an Oracle DB, that's heavily relying on c-shell scripts, and we need to have a DIRECT link between Oracle scripts and the c-shell scripts. In other words, we want to run any of our c-shell scripts at any time from the Oracle DB (throught stored procedures, or preferrably, embedded SQL code in PowerBuilder)

CAN ANY ONE HELP?

Any word regarding

1- Easiest way to call the scripts
2- minimum login requirements(one id/one password for both DB & application)Without using OS Authentication method in Oracle
3- How to call SQL loader from Oracle SQL (Without having to go to OS)

By the way:

Application scripts are on machine A
DB Server is on machine B
Client invoking scripts will be from a PC(Powerbuilder application)

Highly appreciate it,

Thanks

ASKER CERTIFIED SOLUTION

gljr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

iozturk

Pls clearify your question. What kind of scripts? What is your Oracle version? What do you mean by without having to go OS to use SQLLoader? etc.

walterecook

No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: gljr {http:#8105136}

Please leave any comments here within the next four days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

walterecook
EE Cleanup Volunteer