1 Reply Latest reply: Mar 4, 2013 8:30 AM by Timo Hahn RSS

    How to call plsql procedure or function and getting back the string?

    925715
      Hi Everyone,

      i am using Jdev 11.1.1.5.0.
      i have a requirement to call plsql procedure or function from my backing bean java file and get back the returned value from the procedure or function.
      what piece of simple code i need to write in my backing bean?
      please suggest.

      Thanks.
        • 1. Re: How to call plsql procedure or function and getting back the string?
          Timo Hahn
          As always you write the method to call he pl/sql in the application module, expose this method to the client (so you see it in the datacontroll) then create a operation binding to the method and call this operation from the bean. The result you get by operation.getResult();
          You should never call pl/sql from the bean directly!
          The doc shows how to call the procedure from an application module: http://docs.oracle.com/cd/E21764_01/web.1111/b31974/bcadvgen.htm#sm0297


          Timo