Re: Help: UTL_FILE.FOPEN limit

Write a script to a text file using DBMS.OUTPUT.

susana73_at_hotmail.com wrote:

> Hi, I am trying to use UTL_FILE package to dump out tables into text format.
> However, UTL_FILE.FOPEN has a limit of 1024 characters(does it make sence for
> a database?!). So I tried to modify the internal default package in
> /orant/rdbms/admin/utlfile.sql : FUNCTION fopen(location IN VARCHAR2,
> filename IN VARCHAR2, open_mode IN VARCHAR2, max_linesize IN
> BINARY_INTEGER) ### I add this line RETURN file_type;
>
> then run it as SYS, and rewrite my procedure:
> utl_file.fopen('c:\','filename','w',2000);
> ...
> However, when I execute it, I got the following err:
> ERROR at line 1:
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at "user_name.procedure_name", line 44
> ORA-06512: at line 1
>
> What happen? Am I not suppose to modify the default sys package?
>
> Thanks!!
>
> Susana
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Dec 08 1998 - 00:00:00 CST