2 Replies Latest reply on Aug 17, 2004 4:48 AM by 422716

    ORA-06550: Error in Oracle InterConnect DB Adapter

    422716
      Hi,

      We are facing a problem while inserting a row into
      Oracle database using Oracle InterConnect DB Adapter.

      All the required configuration information like AppViews,CommonViews,Events,Application etc have been
      created and configured in iStudio.

      At runtime, OracleDB Adapter bridge (subscription) gets
      the message from the interconnect hub and throws the
      following error, while trying to insert the details into
      table.

      **********************************************************
      Error: db_bridge_writer_1 could not write the message to
      the database because of an application error (java.sql.SQLException: ORA-06550: line 1, column 7:
      PLS-00201: identifier 'EMPLOYEE_OBJ.SUB_NEWEMPLOYEE_OAI_V1' must be declared
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored
      ) in the application stored procedure. Please check your stored procedure. (Em
      ployee_Obj.NewEmployee:OAI/V1,OAI/V1,false,0
      EMPNO: 1000.0
      FULLNAME: aaaaaaaaa
      MANAGERNAME: sss
      DIVISIONNO: 19.0
      ) was not written to the database.
      java.sql.SQLException: ORA-06550: line 1, column 7:
      PLS-00201: identifier 'EMPLOYEE_OBJ.SUB_NEWEMPLOYEE_OAI_V1' must be declared
      ORA-06550: line 1, column 7:
      PL/SQL: Statement ignored

      at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:189).........
      **********************************************************


      Following is the stored procedure that was defined in the
      iStudio at the design time.
      **********************************************************
      ---------------------------------------------
      PROCEDURE sub_NewEmployee_OAI_V1(
      EMPNO IN NUMBER,
      FULLNAME IN LONG,
      MANAGERNAME IN LONG,
      DIVISIONNO IN NUMBER
      )

      AS
      dummy NUMBER;
      -- fill declarations here
      BEGIN
      -- fill code here
      dummy:= 0;
      'insert into employee values(EMPNO, FULLNAME,MANAGERNAME, DIVISIONNO)';
      END sub_NewEmployee_OAI_V1;
      **********************************************************

      What could be the reason for this error? Are we missing
      something in the configuration?

      Appreciate any pointers in solving this issue.

      Thanks in advance,

      Regards,
      Murali.
        • 1. Re: ORA-06550: Error in Oracle InterConnect DB Adapter
          416900
          Murali,

          Where have you installed the Package EMPLOYEE_OBJ in your database?

          It sounds like you've missed this vital step.

          In iStudio...File > Export PL/SQL. Expand your subscribing Application (e.g. APPS) ... APPS > Subscribed Events, and highlight "Subscribe(EMPLOYEE_OBJ.NEWEMPLOYEE)". Press the "Browse" button, and select where you want to save the file. (e.g. d:\iStudio_Packages\XXOAI). The "XXOAI" prefix is added to the start of the created file.

          A *.sql file will be created in the directory you specified (e.g. d:\iStudio_Packages\XXOAI_APPS_EMPLOYEE_OBJ.sql).

          (Note: Ignore the empty "XXOAI_APPS_EMPLOYEE_OBJTypes.sql" file as you haven't created any new ones (i.e. NUMBER and LONG are standard))

          Login to SQL*Plus now, as the same user specified in your DB Adapter.ini file (Hint: In adapter.ini, look for the entry "db_bridge_schema1_writer_username=[Your DB User]", e.g."db_bridge_schema1_writer_username=APPS.)

          Execute the iStudio generated XXOAI_APPS_EMPLOYEE_OBJ.sql file.

          You will now have the Package EMPLOYEE_OBJ created, together with a procedure SUB_NEWEMPLOYEE_OAI_V1.

          You will notice that the DB Adapter (unless you've stopped it and cleared down any persistence files), will automatically find this new Package and Procedure, and will have updated your 'Employee' table. :-)

          Hope this helps
          Ian
          • 2. Re: ORA-06550: Error in Oracle InterConnect DB Adapter
            422716
            Hi Ian,

            Its working now, thanks for your help.

            Best Regards,
            Murali