Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> HELP - REMOVE document problem in Oracle 10g

HELP - REMOVE document problem in Oracle 10g

From: Radosław G±siorek <rg_at_ambsoft.pl>
Date: Wed, 10 Nov 2004 10:04:45 +0100
Message-ID: <cmsl6i$jit$1@achot.icm.edu.pl>


Hello
I'm working on Oracle Portal (10g)
I'm thinking about one problem:
- how to phisicly remove document form the Oralce repository using PL/SQL
Does removing row from WWDOC_DOCUMENT$ remove file from hard disk (some trigers on Delete?).

BTW:
There is one strange (for me ;) ) behavior: I create an item with attarche file (file item) what happent:
- in table WWDOC_DOCUMENT$ is new row for new file created.

Now I would like to remove file but not item (still using PL/SQL). I use function for example:
PORTAL.Wwdoc_Api.remove_document('101801.BMP');

This function remove path id and filename but not whole file itself (but this is less problem). And othere more important problem: aftere PORTAL.Wwdoc_Api.remove_document called in item rows there is still pointer to just deleted file in filelds: FILENAME and VALUE. I would like to do this fields null. - in othere way there is exception durring page deletion (no document found).

I use:
update portal.wwv_things p1
set
p1.FILENAME = null,
p1.VALUE = null
where p1.ITEMTYPE like 'basetext'

and p1.LANGUAGE = wwctx_api.get_nls_language
and p1.SITEID = pagegroupID
and p1.CORNERID = pageID
and p1.filename like '101801.BMP' ;

But this seems to not work at all.

Any body else had some problems like me? How it was solved.

BTW: I work with item versioning.

BIG THANKS YOU FOR ANY HELP Radosław G±siorek
e-mail: rg_at_xmbsoft.pl

                x->a
Received on Wed Nov 10 2004 - 03:04:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US