Home » SQL & PL/SQL » SQL & PL/SQL » How to use Substitution Variables in Pl/SQL
How to use Substitution Variables in Pl/SQL [message #395700] Thu, 02 April 2009 05:33 Go to next message
satipau
Messages: 1
Registered: April 2009
Junior Member
How can we use the &p_grade substitution variables in the PL/Sql to give input from the user
Re: How to use Substitution Variables in Pl/SQL [message #395701 is a reply to message #395700] Thu, 02 April 2009 05:36 Go to previous messageGo to next message
Michel Cadot
Messages: 64130
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No.
PL/SQL executes on the server and only on the server and does not interact with client.

Regards
Michel
Re: How to use Substitution Variables in Pl/SQL [message #395724 is a reply to message #395700] Thu, 02 April 2009 07:51 Go to previous message
joy_division
Messages: 4641
Registered: February 2005
Location: East Coast USA
Senior Member
create a procedure with parameters and call the procedure.
Previous Topic: ORA-22285: non-existent directory or file for FILEOPEN operation
Next Topic: Trigger exception
Goto Forum:
  


Current Time: Wed Dec 07 08:30:41 CST 2016

Total time taken to generate the page: 0.24588 seconds