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') ,
WHERE any_path = p_path;
versionId NUMBER := 0;
activityId NUMBER := 0;
returnmsg VARCHAR2(140) := NULL; ....