Please explain why a procedure cannot obtain user input. I've read about PROMPT and ACCEPT, as well as a little on DBMS_PIPE, but am not understanding very well. I'm a beginner to PL/SQL. If I have two stored procedures and the first asks for user input and the second displays a menu. I call the stored procedures, but all I get is the menu. What are the workarounds for this?
PL/SQL is designed to work silently on servers and applications
like Oracle Forms and Oracle Reports.
To accept user input you have to use tools and languages that
are designed to do this.
A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
This way, I guessed, I would ensure that use…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…