Home > IT Answers > Oracle > How to execute iSQL*Plus script from Oracle Portal
Ws8oBPSQ
15 pts.
 How to execute iSQL*Plus script from Oracle Portal
Oracle
I want to execute a SQL*Plus script which ask for parameters and updates an Oracle table from Portal. Any suggestions on how to do this? Thanks Bonita Graupe

Software/Hardware used:
ASKED: June 6, 2006  9:50 AM
UPDATED: June 12, 2006  1:14 AM
RELATED QUESTIONS
Answer Wiki:
I would suggest creating a stored procedure/package that would accept your parameters. You can create a portal form based on a procedure or you can use the portal PDK.
Last Wiki Answer Submitted:  June 7, 2006  6:48 am  by  NickatMFG   0 pts.
All Answer Wiki Contributors:  NickatMFG   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Not sure what you mean “from Portal”, however, it seems you should use substition and/or bind variables, prompt and/or accept. Not sure this will work but something like

define x varchar(10)

accept “Enter value: ” into &x

update tab1 set col1 = &x;

good luck.

Cscottmitchell
 0 pts.