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