1 Reply Latest reply on Nov 21, 2016 12:07 PM by Francisco Amores

    Calling procedure in jython

    JanGLi

      Hi,

      I want to call sql procedure in my befimort jython script.


      This is my procedure:

      CREATE OR REPLACE PROCEDURE HYPERION_FDMEE.qqq
      IS
      BEGIN
        UPDATE aif_open_interface SET batch_name = 'xxxx'  WHERE period = 'MAY';
        commit;
      END;
      

      and this is my jython befimport script

      import java.sql as sql
      import com.hyperion.aif.scripting.API as API
      fdmAPI = API()
      conn = sql.DriverManager.getConnection("jdbc:oracle:thin:@ip:1521:sid", "username", "pass");
      cursor = conn.cursor()
      cursor.callproc('qqq')
      conn.close()
      

       

      I can't get this script correct.

      Should i import other libraries?

       

      Kindly guide i am totally new at this

       

      Regards