May i know Is there any way to execute a named pl/sql block created in different schema OTHER THAN through synonym / 'grant execute' rights ?
Please share your answers here.
Thanks in advance.
No Comments Posted for this Article.
Introduction to PL/SQL
Need for PL/SQL â declarative vs. procedural â anonymous blocks â debugging â a first program â code compilation â code execution â procedures & functions â...
Error in PL/SQL block of trigger
I have written a trigger whose PL/SQL block contains a simple select statment among many other statements. Now I find that, if the select statement returns no rows the trigger does not continue its...
What is PL/SQL tables?
What is PL/SQL tables. When and why they are used. PL/Sql table is a virtual array(single array) table defined during runtime.These tables help u in storing,manipulating in a blocks thus...