|
-
Hello
did you try using a substitution variable.
Select ename, mgr from emp where empno = &eno;
Here, eno is the substitution variable ( it is preceeded by a & to indicate that it is a substitution variable ) and oracle prompts the user to provide value for this variable. This may not be the exact alterntive to ACCEPT, but some what usefull in certain cases.
Also i haven't figured out how to use the value the user had given for this sunstitution variable ( eno ) elsewhere in the PLSQL block. Using it as &eno will cause oracle to prompt again and using it as eno gave me errors.
Hope this helps you,
Cheers,
Prasad
Prasad
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
|