Error to generate text file

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
Post Reply
Tinho
Rank: DBA Sênior
Rank: DBA Sênior
Posts: 317
Joined: Mon, 16 Nov 2009 4:50 pm
Location: São Paulo - SP

Good afternoon, companions.

"Oracle Error: ORA-29285 File Write Error".

Please, I would like to know how to identify in the code what is causing this error. I'vê already turned up to top down, but I can not find what's wrong. Also I have already performed some consultations on the Internet to see if there was a solution, but all the answers are very "superficial" being related to recording permission in the folder, if the file is read only and does not write, also the attempt to open a file that is already open or attempt to write to a closed file.

follows one of the answers I encountered:

Select all

 
 
 "Verifique se o arquivo existe, que é acessível, e que está aberto no modo de escrever ou acrescentar." 
 
 "Falha ao gravar, flush, ou fechar um arquivo." 
 
 
Who can help me, I am grateful .

Att.
diegolenhardt
Moderador
Moderador
Posts: 1177
Joined: Thu, 15 Oct 2009 10:28 am
Location: Recife

Does this procedure work ever?

Checks permissions in the operating system for this Directory,
See if your user in the database has Grant de Read / Write on Directory,

99] and the parameter utl_file_dir

Select all

select * from v$parameter 
where name like '%utl%'
Tinho
Rank: DBA Sênior
Rank: DBA Sênior
Posts: 317
Joined: Mon, 16 Nov 2009 4:50 pm
Location: São Paulo - SP

Hello, thanks.

Problem solved. It is that when access to procduration was done by the application in the testing environment, the user who was logged in did not have the permissions required for such purpose.

Att.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 9 guests