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

Report message to a moderator

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: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 12 19:54:51 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.