This discussion is archived
9 Replies Latest reply: Feb 5, 2013 9:47 PM by user346369 RSS

how to call a function, which name is stored in table?

user2040934 Newbie
Currently Being Moderated
Dear members,

I have a function with return number, and store its name in a table.

now I want to select this function name from table and run it and return the value to a variable in my form.

here is my code in when-button-pressed trigger.
DECLARE
     v_value number;
     V_FUNC VARCHAR2(100);
     V_PARAM VARCHAR2(100);
begin
     select FUNCTION_NAME, PARAM 
     INTO V_FUNC, V_PARAM
     from function_table
     where id =1;
      
     message('V_FUNC='||V_FUNC); pause;
     v_value := v_func||';'; --run_tb_function;
     :text01 := v_value;
end;
this code gives the following error:

ora-06502


regards:

Edited by: user2040934 on Feb 2, 2013 9:47 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points