OraFAQ Forum: Forms » if the stored procedure name is store in a VARCAHR2, how can i execute such stored procedure in form

Home » Developer & Programmer » Forms » if the stored procedure name is store in a VARCAHR2, how can i execute such stored procedure in form

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

if the stored procedure name is store in a VARCAHR2, how can i execute such stored procedure in form [message #79810]

Mon, 15 July 2002 23:37

Penn Wan
Messages: 1
Registered: July 2002

Junior Member

if the stored procedure name is store in a VARCAHR2
how can i execute such stored procedure in form 6i

Report message to a moderator

Re: if the stored procedure name is store in a VARCAHR2, how can i execute such stored procedure in [message #79811 is a reply to message #79810]

Tue, 16 July 2002 01:05

Subhash
Messages: 105
Registered: October 2001

Senior Member

You have to use 'Dynamic SQL'
Eg:
procedure dyn_proc (proc_name in varchar2) is
str long;
run pls_integer;
cursor_name pls_integer default dbms_sql.open_cursor;
BEGIN

str := 'begin ' || proc_name||'; end;';
dbms_sql.parse(cursor_name, str, 1);

run := dbms_sql.execute(cursor_name);

END;

Report message to a moderator

Previous Topic:	Query Only Form
Next Topic:	list item- Form Builder 6.0

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 12 03:31:39 CST 2025