Execute a Procedure

[MoQ]

How do I execute a procedure in 6.0.6.947 with string parameter; the following gives an error "ORA 06508: PL/SQL: Could not find program until being called"

begin
ds_dmemployee.get_employee(zz => :zz,
cur_employees => :cur_employees);
end;

create or replace package body DS_DMEmployee
as
procedure get_employee(zz in varchar, cur_employees out t_cursor)
is
begin
open cur_employees for select DMEMAIL from dm_employee where ahRole = "Manager";
end get_employee;
end DS_DMEmployee;

create or replace package DS_DMEmployee
as
type t_cursor is ref cursor;
procedure get_employee(zz in varchar, cur_employees out t_cursor);
end DS_DMEmployee;

 

[Theod]

Hi,

may bee wrong order, or wrong parameter-syntax?

I'd first create the package, then the body and then call the procedure.

I'm not familar with PLD 6.0.. but try '&zz' instead of :zz in an sql-window or an command-window.

 

[patch]

Are you testing in a test window? If not, do so. If you are, wrong click (that with the right mouse button) in the variables section on the bottom of the screen and then select 'Scan Variables'. Now you have to set the types and values but you should be good to go.

Kindest regards,
Patrick Barel