Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » suse oracle »

[suse-oracle] UTL_FILE Problem

Reinhard Henjes

2006-02-06


Hi List..
I've a 9.0.1 DB on SuSE linux 7.3
in a TRigger while deleting i do a
fileHandle := utl_file.FOPEN_NCHAR
('/opt/oracle/savdata','arbeiter_'||:OLD.IND||'_values','a');
this works very well.


on SuSE 9.0 and Oracle 9.0.2
the same Trigger causes an Error. whith the File ID in UTL_FILE Package.
doing the same "delete" on the Table again the Trigger works... ?

has anyone an idea....



viele GrĂ¼sse aus Obernkirchen

Reinhard Henjes

--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting

©2008 dba.5341.com - Jax Systems, LLC, U.S.A.