> You mean something like:
> execute dbms_backup_restore.deletefile('$ORACLE_HOME/bin/oracle')
Yes.
>
> (I'm not sure the $ORACLE_HOME bit would literally work
> by the way).
Phew!
>
> It's certainly a case where you should hide the procedure
> call in a package which exposes only the deletefile()
> procedure from the dbms_backup_restore package.
> (A bit like the dbms_lock, user_lock packages).
> In that case, you could always wrap the call in a piece
> of code (e.g. asks for a directory in the utl_file_dir
> list, and a file name, validates the directory using
> a utl_file call, and then deletes the file).
>
>
Thanks.
I'm all for giving developers as much as possible, within reason.
Certainly "hiding" the procedure in a package as you suggest is fine, and
would allay most of my fears.
George Barbour.
Received on Mon Jan 28 2002 - 08:00:16 CST
