Monday, 2 September 2013

dynamiclly calling procedure in oracle

dynamiclly calling procedure in oracle

I want to call procedure whos name has been enter by the user.. how can do
it..
for example: i want to call procedure1 in pocedure2
create or replace procedure procedure1
(a in number,
b in number
cv_1 out sys_refcursor
)
as
begin
....//doin something
end;
procedure2:
create or replace procedure procedure2
(procedure1name in varchar2,
a in number,
b in number,
cv_1 out sys_refcursor
)
as
begin
....//call procedure1 and return cv_1
end;

No comments:

Post a Comment