Invoke oracle stored procedure from shell script without SQLPLUS

Question

Can anyone please suggest a way to invoke an Oracle stored procedure from a shell script without the use of SQL*Plus, or any such client for that matter. The inability to install clients is a limitation of the server that I work on.

I have to schedule an Autosys script to invoke the job which invokes the Oracle stored procedure. Can you please suggest in what direction should I proceed?

Java and jdbc have been suggested by @ik_zelf. Similarly, if you have Perl, Ruby, Python or similar scripting languages with a built-in database facility you may be able to get to your database. — Bob Jarvis - Слава Україні, Jun 06 '12 at 02:37

score 3 · Accepted Answer · answered Jun 05 '12 at 21:03

3

You could do this using Java and jdbc. If you can not even copy the thin jdbc driver, I see no other option than to schedule the job in Oracle Using Oracle Scheduler.

answered Jun 05 '12 at 21:03

Thanks. I think I Oracle scheduler seems the only option for me. – juggernaut Jun 06 '12 at 14:54

score 0 · Answer 2 · answered Jun 05 '12 at 20:05

0

Without client software installed, you'll have a hard time getting to Oracle from a shell script; however, Oracle has it's own batch facility--see Database jobs here

answered Jun 05 '12 at 20:05

Pughjl

156
7

Invoke oracle stored procedure from shell script without SQLPLUS

2 Answers2