Home » Infrastructure » Linux » How to Call pl/sql procedure from shell script
How to Call pl/sql procedure from shell script [message #500724] Wed, 23 March 2011 02:43 Go to next message
Messages: 22
Registered: December 2010
Junior Member

I've one procedure which takes the xml file name as input from one of the remote location. Every day users keep one file in that location.
For eg:


I need to read the latest file in this case. In this case second one is the latest file.

Can some body please help me how to write script to pass parameter to that procedure that via shell program and execute that.

Thanks in advance.

Re: How to Call pl/sql procedure from shell script [message #500728 is a reply to message #500724] Wed, 23 March 2011 03:18 Go to previous message
Michel Cadot
Messages: 68342
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ PL/SQL cannot read remote location.
2/ Solutions depend on your Oracle version, so ALWAYS post it (with 4 decimals).

Previous Topic: Schedule Tasks
Next Topic: How to create Mount Point in Linux
Goto Forum:

Current Time: Mon Jan 30 22:38:00 CST 2023