utl_file and null string \0

From: <mkanar_at_my-deja.com>
Date: 2000/06/21
Message-ID: <8ira0f$p06$1@nnrp1.deja.com>#1/1

I am trying to extract the source code including triggers for a project. Every thing runs well except that I am getting end of string ( null '\0') from user_triggers. My idea is:
- extract source from user_source and user_triggers

put the source to file using UTL_FILE.

The source in user_source and user_triggers is stored in columns which have LONG data type.

I tried to use replace but it doesn't work.

Any idea how I can remove nulls.

Thanks,

Michael

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jun 21 2000 - 00:00:00 CDT