Help for downgrading a script from 10g to 9i

From: Frederic <fh_at_ionicsoftDOTcom>
Date: Tue, 07 Dec 2004 11:58:59 +0100
Message-ID: <41b58cbd$0$2014$6c56d894@feed0.news.be.easynet.net>

Hi all,

I have a script that use XDB capabilities :

• Creates the XMLDB user home folder -----------------

DECLARE

	retb boolean;
	exist boolean;
BEGIN
	exist := DBMS_XDB.EXISTSRESOURCE('/home/SCOTT');
	IF NOT exist THEN
		retb := dbms_xdb.createfolder('/home/SCOTT');
	END IF;

end;
/

• Assign all privilege for user to his home folder --------

update resource_view e set e.RES =
UPDATEXML(e.RES,'/Resource/Owner/text()','SCOTT') where e.ANY_PATH = '/home/SCOTT';

I cannot find ExistResource equivalent under 9i.

Who can help me ?

thanks

Frederic Received on Tue Dec 07 2004 - 04:58:59 CST