Using ACCEPT and PROMPT in PL/SQL scripts

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? Received on Tue Oct 29 2002 - 08:46:47 CST