Exception (treat disk space)

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Mon, 16 Jan 2006 6:17 pm

[color = blue]
Guys, good afternoon.
[/color]

I wonder if there is a way I get the following exception: Example: UTL_FILE ... I'm recording on a disc and, if the disk space is not sufficient, I would treat a exception.

Someone would know how to handle such an exception????

Would have to perform some computation or disk, there is an exception of the Oracle himself to this?

Thank you very much..


_____________________________________
[Trevisolli]
Trevisolli
Location: Araraquara - SP

Poston Tue, 17 Jan 2006 8:24 am

I didn't get to test, but I think you can capture the exception WRITE_ERROR.

See a link with the exceptions of UTL_FILE http://www.glufke.net/oracle/viewtopic.php?t=381:-
dr_gori
Location: Portland, OR USA

Thomas F. G

Você já respondeu a dúvida de alguém hoje?
http://glufke.net/oracle/search.php?search_id=unanswered


  • See also
    Replies
    Views
    Last Post


Return to PL/SQL

Who is online

Users browsing this forum: No registered users and 8 guests