3 Replies Latest reply on Oct 19, 2006 5:16 PM by 475314

    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