1 Reply Latest reply: Jul 27, 2012 10:25 AM by OPR RSS

    Error adding defaultPackage clause in XML Publisher

      Hi XML Gurus

      I'm trying to output data using data templates in XML Publisher.
      My data template dumps XML data ok, but if I add defaultPackage clause , then I get this messagge executing concurrent:

      XDO Data Engine Version No: 5.6.3
      Calling XDO Data Engine...
      [072612_054320130][][EXCEPTION] SQLException encounter while executing data trigger....
      java.sql.SQLException: ORA-06550: line 2, column 11:
      PL/SQL: Statement ignored
           at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
           at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)

      No dataTrigger elements exist.
      Offending clause seems to be: defaultPackage="MY_PKG"
      MY_PKG is an existing package in apps schema.

      Of course, I can delete defaultPackage attribute, but my next step is to use dataTrigger(s)

      Any guidance please