3 Replies Latest reply: Oct 19, 2006 12:16 PM by 475314 RSS

    OTN CMSXDB application error

    73453
      Hello,

      has anyone experienced the same problem when trying to setup the XML based Content Management application?

      When configuring the application by running SQL>@<SAMPLE_HOME>/sql/install.sql
      script otncms_xmlcontent.plb gets called by install.sql.
      In line 52 (after all comments and blank lines were taken out) the following function is called:
      FUNCTION checkresourcestatus (abspath IN VARCHAR2) RETURN VARCHAR2 IS
      CURSOR c_version(p_path VARCHAR2) IS
      SELECT extractvalue(res, '/Resource@VersionID') ,
      extractvalue(res, '/Resource@ActivityID')
      FROM XDB.resource_view
      WHERE any_path = p_path;
      versionId NUMBER := 0;
      activityId NUMBER := 0;
      returnmsg VARCHAR2(140) := NULL; ....

      Resulting in the following output error:

      Creating CMS packages

      Package created.

      No errors.

      Commit complete.

      **** FINISHED creating otncms_xmlcontent.pls *****

      Warning: Package Body created with compilation errors.

      Errors for PACKAGE BODY OTNCMS_XMLCONTENT:

      LINE/COL ERROR
      -------- -----------------------------------------------------------------
      52/5 PL/SQL: SQL Statement ignored
      52/12 PL/SQL: ORA-31013: Invalid XPATH expression
      1330/3 PL/SQL: SQL Statement ignored
      1330/10 PL/SQL: ORA-31013: Invalid XPATH expression

      Commit complete.

      Creating public synonym

      Synonym created.

      Grant execute to public

      Any ideas or suggestions would be greatly appreciated.

      Thank you very much,
      Rosi MacLean