Re: connect to db oracle using plsql

Hi Claudia,

you can manage these errors because you can define an exception for any ORA-xxxx using
pragma exception ... (see docs for syntax) then you can use it in the exception handler to catch the error, just watch out which is the first on the stack.

The blocking of the function presumably results from some TCP/IP connection timeout when the DB tries to establish the dblink, the function has to wait until failure is detected by reaching timeout.

Regards
  Tibor

"Claudia Gambetta" <claudiagambetta_at_tiscali.it> wrote: news:9814fb76.0206020811.70e55044_at_posting.google.com...
> hello to all, and thanks of your aid, only, that I have tried to write
> a function with the cursore having a select * from
> schema.tabella_at_db_link, that if db the correspondent to the db_link is
> not connected the function only blocks and from these errors, without
> the possibility to manage them through exception.Come making then.
> Thanks still hello claudia
>
> errors:
>
> ORA-04052 ERRORE VERIFICATOSI DURANTE LA RICERCA DI OGGETTO REMOTO
> NOME_SCHEMA.TABLE_at_DB_LINK
>
> ORA-00604 ERRORE RISCONTRATO IN SQL RICORSIVO LIVELLO 1
> ORA-12535 TNS OPERAZIONE FUORI TEMPO
Received on Mon Jun 03 2002 - 09:16:35 CDT