OraFAQ Forum: SQL & PL/SQL » how to clear the output data using utl

Home » SQL & PL/SQL » SQL & PL/SQL » how to clear the output data using utl_file?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to clear the output data using utl_file? [message #639978]

Tue, 21 July 2015 02:05

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi all,

how to clear the output data using utl_file?

v_handle := utl_file.fopen(v_dirname,v_file_name,'w');
for loop
 ......
 ......
end loop;
utl_file.fclose(v_handle);

I will out put values in the file, then how to clean these values?

Report message to a moderator

Re: how to clear the output data using utl_file? [message #639982 is a reply to message #639978]

Tue, 21 July 2015 02:12

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What do you mean by "clean" or "clear"?

Report message to a moderator

Re: how to clear the output data using utl_file? [message #639983 is a reply to message #639982]

Tue, 21 July 2015 02:19

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Quote:

What do you mean by "clean" or "clear"?

Thank you for early reply Michel , i need to clear(remove the unwanted data in the output).i think messages are overwriting in the output file

Report message to a moderator

Re: how to clear the output data using utl_file? [message #639984 is a reply to message #639983]

Tue, 21 July 2015 02:22

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And what are the unwanted data?
And what is "output"? The file you opened?
And what did you mean by ".i think messages are overwriting in the output file"?

So explain in details what is your problem.
Show us your code, show us its execution, show us what is the problem.

[Updated on: Tue, 21 July 2015 02:22]

Report message to a moderator

Re: how to clear the output data using utl_file? [message #639986 is a reply to message #639984]

Tue, 21 July 2015 02:25

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Quote:

And what are the unwanted data?

Means, in the output file showing succeeded data in the file
Quote:

And what is "output"? The file you opened?

we are trying to get data in the output file to show some data
Quote:

And what did you mean by ".i think messages are overwriting in the output file"?

same as 1 answer

Report message to a moderator

Re: how to clear the output data using utl_file? [message #639987 is a reply to message #639986]

Tue, 21 July 2015 02:31

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Means, in the output file showing succeeded data in the file

This does not answer my question.

Quote:

same as 1 answer

Still don't understand.

Quote:
So explain in details what is your problem.
Show us your code, show us its execution, show us what is the problem.

Report message to a moderator

Re: how to clear the output data using utl_file? [message #639989 is a reply to message #639987]

Tue, 21 July 2015 03:09

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

I have used package , fetching the data using cursor for loop(if there is any error's occur's) , in the data loading there is no error's are there , messages are overwritten

And i will try to post more description on this

Report message to a moderator

Re: how to clear the output data using utl_file? [message #639990 is a reply to message #639989]

Tue, 21 July 2015 03:11

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

We are waiting for you...
How does it come that with more than 1000 posts you still don't know you have to show us what you do and get?

Report message to a moderator

Re: how to clear the output data using utl_file? [message #640007 is a reply to message #639990]

Tue, 21 July 2015 05:25

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

I have a log file that has a bunch of stuff in it that I don't need anymore. I want to clear the contents.
Is there a way to do it in one command without destroying the file to do it?

Report message to a moderator

Re: how to clear the output data using utl_file? [message #640008 is a reply to message #640007]

Tue, 21 July 2015 05:28

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

How is this related to Oracle?

Report message to a moderator

Re: how to clear the output data using utl_file? [message #640009 is a reply to message #640008]

Tue, 21 July 2015 05:42

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Quote:

How is this related to Oracle?

This is related to Oracle Apps Concurrent Program View Output File data, in this file report data is overwritten , i am calling packages and getting output files

Searched in the Google
$ cat /dev/null > t

How to use and where to use this $ cat /dev/null > t?
  sql_error=`grep "^ERROR" $tfile` 

    cat ${tfile} >>$OUTFILE
    cat ${tfile} >>$LOG
    
    mv $OUT_DIR/XXC_DATA.dat $OUTFILE

[Updated on: Tue, 21 July 2015 05:43]

Report message to a moderator