1 Reply Latest reply: Jul 1, 2013 2:52 PM by Chiwatel RSS

    Calling Oracle Stored Procedure from Weblogic.

    Chiwatel

      Hi All,

       

      I am using Oracle 11g R2 and weblogic 10.3.5.0

       

      Do you know if it is possible to call a stored procedure from Weblogic.

       

      Basically, what I would like to do is to call the following procedure : EXEC DBMS_SESSION.SET_IDENTIFIER('provider_a') when my application connects to my database, "provider_a" being the user used to connect to the oracle schema.

       

      Thanks.