Unanswered: Can PL/SQL Acccept an inputted variable?
My "Query" refers to the ability to input variables in a PL/SQL Procedure.
Basically I am able to to input variables using the normal method
Exec procedure(variable1, variable2)
However I want to know if it is possible to code in such a way that the user inputs a variable when requested by the code:
For instance when the procedure is run, I want the DBMS to ask questions and accept the variables I put in to answer them
Sort of like the DBMS_OUTPUT but in reverse.
This is not possible...normally the database server running far away from the user and can't interact directly with him/her.
For such inputs you must implement a frontend...maybe an ms-access frontend can solve your problem.