Re: Help: UTL_FILE.FOPEN limit

UTL_FILE declare new data type - FILE_TYPE. For PUT functions is limit of buffer size 1023 B, for GET functions is 1022 B. Those limit values are fixed (don't change !!!). You can output dump create per partitions. This is solution your problem.

susana73_at_hotmail.com wrote in article <73cak5$23h$1_at_nnrp1.dejanews.com>...
> 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 Nov 24 1998 - 00:00:00 CET