screen input for pl/sql

[kris123]

Hi Friends,

How to or ...
Can PL/PQL be able to prompt and accept user input
from screen? (e.g.) "Please Enter Process Date (format yyyymmdd)"


Thanks,

[slimdave]

Not in a function, procedure or package, which are entirely serverside processes.

Through SQL*Plus you could prompt for and accept a value, then pass it to a procedure, or use it in an anonymous block of PL/SQL