How to Execute a Stored Procedure in Oracle 11g

Question

Hi I'm spending a lot of time searching for execution of stored procedures in Oracle 11g. If anyone can share the answer that will be so helpful.

Regards, Pranay.

Solution 1

It's not working if I press F5 but it's working if I highlight the Execute Statement and right click and press Run the Script Option. I got help from my Colleague AK.

Eg:

Var result1 refcursor; EXECUTE Schemaname.Tablename (param1,param2,:result1); print result1

Regards, Pranay.

Solution 2

You call it with execute:

EXECUTE my_procedure ('arg1', 'arg2');

Solution 3

If your cursor is a ref cursor:

declare
  lcsr sys_refcursor;
begin
  package.procedure(input => input_parameter_value, output => lcsr);

   /* Do something with lcsr */
end;

Solution 4

I had same problem, and I found lot of posts without answers. This is solution:

begin your_procedure; end;

View more solutions