9 Replies Latest reply: Feb 5, 2013 11:47 PM by user346369 RSS

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

    user2040934
      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