0 Replies Latest reply: Feb 15, 2013 12:16 PM by Andy Hardy RSS

    How to use PL/SQL procedure/function in Resource Template (listener 1.1.3)?

    Andy Hardy
      Hi,

      I'd like to call an existing function/procedure from a resource template. For example, I have a procedure called 'rest' with an out parameter of 'p_out' - how do I use this within a resource template?

      At the moment I have defined the template as type 'PL/SQL Block' and with the 'GET' defined as:

      begin
      myschema.rest(:p_out);
      end;

      APEX_PUBLIC_USER has been granted 'all' on the procedure. The p_out is populated with a piece of text.

      When I call this resource, I get a '500 Internal Error' returned. I've tried adding p_out as an X-APEX-FORWARD parameter, but nothing seems to work.

      Query-based templates seem to work OK.

      Using Listener 1.1.3 with Tomcat6.

      Help!