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
chanveil
Messages: 22
Registered: December 2010
Junior Member
Hi,

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:

ACS_RPO00020110316_20110316220956.xml
ACS_RPO00020110319_20110319220956.xml

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.

Regards
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: 68625
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).

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


Current Time: Thu Mar 28 16:27:37 CDT 2024