PL/SQL [message #4222] |
Wed, 20 November 2002 00:42 |
sriram
Messages: 58 Registered: September 2000
|
Member |
|
|
Hi all
I want to write a PL/SQL procedure which when executed, will prompt for a number, print "less than 100" if the entered number is lesser than 100 OR print "equal/more than 100" if the entered number is equal/greater than 100.
Requirement is that, I cannot pass the same as arguments, rather, the code should primpt for the inputs when executed (exec).
Please send me the code for the same.
This is urgently needed.
Regards
Srirama
|
|
|
Re: PL/SQL [message #4224 is a reply to message #4222] |
Wed, 20 November 2002 00:59 |
F. Tollenaar
Messages: 64 Registered: November 2002
|
Member |
|
|
Procedures are stored in the db. They must be able to run without any frontend at all, so it is NOT possible to intervene with them. (Not possible to prompt for input).
hth
Frank
|
|
|