-
1. Re: Run PL/SQL Block to test or debug, no generated PL/SQL Block, dialogue box is empty
x but in many cases the actual PL/SQL block is empty... however, not in all cases. There doesn't seem to be a rhyme or reason for which procedures or functions generate the anonymous block
But does the same procedure consistently work or not work? We need an example.
-
2. Re: Run PL/SQL Block to test or debug, no generated PL/SQL Block, dialogue box is empty
When I right click on a PL/SQL Package and select the run option,
You don't 'run' packages.
You need to select a procedure or function within the package to execute.
So it isn't clear at all exactly what you are really doing or want to do.
-
3. Re: Run PL/SQL Block to test or debug, no generated PL/SQL Block, dialogue box is empty
Yes, calling the package/procedure from within a SQL window script works fine :
begin
package_name.procedure_name(arg1,arg2...);
end;
-
4. Re: Run PL/SQL Block to test or debug, no generated PL/SQL Block, dialogue box is empty
Try doing what I said from SQL Developer... it will give you the option to run a procedure/function within the package.
Register and Participate in Oracle's online communities. Learn from thousands of experts, get answers to your questions and share knowledge with peers.