calling procedures in varaveis

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Mon, 01 Nov 2004 5:48 pm

Good afternoon.
I'm saving it on a table, some calls to procedures in fields of type varchar2.
For example, I have a call like this: ATUALIZA_PARMNF (NULL);

After that, within another procedure or trigger would perform these procedures that are stored in the Bank.
Then I do a select: SELECT NM_INSTRUCAO INTO I_NM_INSTRUCAO FROM TABLE WHERE NR_SEQUENCIA = XXXXX;

and after that I would perform the procedure contained within the variable I_NM_INSTRUCAO.

Today I am doing so EXECUTE_IMMEDIATE (I_NM_INSTRUCAO);

Could someone tell me if this idea would work or if you know of any way to do?

Thank you
Zida
Location: Toledo - PR

Poston Mon, 01 Nov 2004 6:10 pm

can do so: EXECUTE_IMMEDIATE (' BEGIN ' || I_NM_INSTRUCAO || '; END; '
);
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered

Poston Mon, 01 Nov 2004 7:50 pm

Thank you very much, now:) funciuonou
Zida
Location: Toledo - PR


  • See also
    Replies
    Views
    Last Post


Return to PL/SQL

Who is online

Users browsing this forum: Bing [Bot] and 10 guests