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 - Слава Україні
– Bob Jarvis - Слава Україні, Commented Jun 6, 2012 at 2:37

user123664 · Accepted Answer · 2012-06-05 21:03:07Z

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 5, 2012 at 21:03

user123664

Sign up to request clarification or add additional context in comments.

1 Comment

juggernaut Over a year ago

Thanks. I think I Oracle scheduler seems the only option for me.

Pughjl · Accepted Answer · 2012-06-05 20:05:14Z

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 5, 2012 at 20:05

Pughjl

1567 bronze badges

Collectives™ on Stack Overflow

Invoke oracle stored procedure from shell script without SQLPLUS

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest