2 Replies Latest reply on Sep 20, 2013 4:33 PM by 1f4b815c-2ab8-4a6c-abd4-fd1d203e4dae

    How to make a remote function call dynamically from a trigger of a Oracle Form 10g?


      I normally use the following technique to make a remote function call from different schema's dynamically, in a regular PL/SQL block.


      column right_instance new_value remtinst

      select DECODE(&1,1,'first_schema',2,'second_schema','default_schema') right_instance from dual;

      error_code := main_remote_call@&remtinst(param1,param2...);


      The same function is defined in all schemas. The choice is dynamically done base on the parameter passed.


      But this techniques doesn't seem to work inside PL/SQL block of a form trigger inside Oracle Form.


      Could someone please help?