-
pl/sql menu and halting for user selection
i want to have user input when running a procedure.
eg
in pl/sql block
SET SERVEROUTPUT ON
ACCEPT P_TEST PROMPT 'PLEASE INPUT THE SALARY : '
I WANT THE SAME THINK TO BE DONE WHEN CREATING A PROCEDURE OR A PACKAGE AND IT SHOULD HALT TILL VALID OPTION IS
SELECTED AND ALSO HOW CAN I HVAE SERVEROUTPUT ON IN PACKAGE AND PROCEDURE.
Saurabh Garg
OCP 9i
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|