Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Using ACCEPT and PROMPT in PL/SQL scripts
Ubiquitous wrote:
> I am attempting to write a quick and dirty PL/SQL procedure that
> would allow one to add a record to a Rather than having to invoke
> the procedure with all the required data elements, I would rather
> have the script prompt the user for each data element before
> performing the INSERT.
>
> However, this is turning out to be easier said than done. I found
> an example in a PL/SQL book but when I tried to run it in a SQL*PLUS
> session, it would either return an error when it encountered the
> ACCEPT line ("Not a valid SQL statement") or would return the incorrect
> prompt.
>
> I'll have to grab the sample code I used, but do you think of anything
> obviously wrong?
It can not be done. Rethink your strategy.
Daniel Morgan Received on Tue Oct 29 2002 - 10:53:02 CST