Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

utl_file.fopen

phani marellaJun 12 2009 — edited Jun 12 2009
Hi everyone..

I am using utl_file to write delimited data into text files.In the utl_file.fopen i changed the default l "max line size" to 32767 when i got some error regarding the line size.After changing that that max line size paramaterer,I am getting lot of space after each line.
Does that max line size parameter means that every line "should" be that size? why i am getting lot of space after each line?

question1:
======
How to remove that empty spaces that i got after each line in my text file?
FILEHANDLE := UTL_FILE.FOPEN('TEST_UTL_FILE','file_name.txt', 'W',32767);
And i am trying to find the length of the string that i am passing it utl_file.put_line
I am trying to insert that length to a "test" table ,so that i can check the max length of each line that is passing to the utl_file.
I have this insert command in my PL/SQL block
insert into test_number_char (num) values (dbms_lob.getlength(EXTRACTED_STRING)); and the data type of "num" column is number(20,0)
I am getting the following error .
ERROR getting members -1461 ORA-01461: can bind a LONG value only for insert into a LONG column
question 2:
=======
How to get the length of the string that i am writing into file?

Thanks
phani
This post has been answered by Christian Balz on Jun 12 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 10 2009
Added on Jun 12 2009
10 comments
3,409 views