Home » SQL & PL/SQL » SQL & PL/SQL » Receiving parameters to Sql script through concurrent program (Oracle Applications ,11.5.10.2,Windows)
Receiving parameters to Sql script through concurrent program [message #355600] Sun, 26 October 2008 03:38 Go to next message
rmasurka
Messages: 5
Registered: October 2008
Location: Bangalore,India
Junior Member
hi,
I have as executable with execution method as SQL* plus,now i want to pass parameters to sql through concurrent program,but it's not working for me Sad
This is how I am getting parameters in sql script.
'&&1' for parameter1
'&&2' for parameter2 and so on.
can anybody guide me how to receive parameters in sql script.
when I am hard coding the values in Sql Script it's workinh fine, this means error somewhere in receiving the parameter.
Re: Receiving parameters to Sql script through concurrent program [message #355607 is a reply to message #355600] Sun, 26 October 2008 06:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
"Is not working for me" does not help us to help you.

Regards
Michel
Re: Receiving parameters to Sql script through concurrent program [message #355612 is a reply to message #355607] Sun, 26 October 2008 06:27 Go to previous message
skooman
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member
Since you mention concurrent program, I assume you are working with EBS/apps, right? If so, you have a better chance on an answer if you post this in the EBS part of the forum.

Regards,
Sabine
Previous Topic: Order by clause difference
Next Topic: Inline View
Goto Forum:
  


Current Time: Sat Dec 03 08:22:14 CST 2016

Total time taken to generate the page: 0.06266 seconds