How to make a stored procedure interactive
Hi,
I want to write a stored procedure with some parameters, but I'd like to make it to wait before to go on according if I choose, for example Yes o No with reference to a spool of date.
I mean I want that the procedure begins to work, then it reports to me a list of information and afterwords it waits before to continue by expecting to my input. It seemed to me there exsisted a native package PCK UTILITY o something like that to do it.
Cna you help me?
Thanks!