URGENT! How can I get the contents of a field in execute command 1

[alexdbora]

I need to execute a procedure .
It's name is in a table which contains many names of procedures.

I have a table named proc_names(id_proc,name_proc)
id_proc name_proc
------- ----------
1 proc1
2 proc2
3 proc3

My command is:

execute <here I need the contents of the field name_proc from table proc_names>


Well,I hope I made myself clear.

hope you help me.

 

[sem]

Use EXECUTE IMMEDIATE

Regards, Dima

http://seminihin.narod.ru

 

[alexdbora]

<Execute immediate> it works in SQL*PLUS,

but I need it in FORMS 6 !!!

 

[sem]

Use FORMS_DDL

Regards, Dima

http://seminihin.narod.ru

 

[sem]

But if you need "portable" solution then the best way is good old DBMS_SQL package.

Regards, Dima

http://seminihin.narod.ru

 

[alexdbora]

Thanks a lot sem!
It works!