Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> HELP - REMOVE document problem in Oracle 10g
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->aReceived on Wed Nov 10 2004 - 03:04:45 CST
![]() |
![]() |