Hello José Carlitos, We are using a SDO_JOIN between two tables. We don´t have any function or pl/sql code in the part where the error occurs. It happend when Oracle is executing an INSERT / select ...
The select instruction has the SDO_JOIN mentioned. This is the issue. I would like to know why does it happen ? What need I reduce for it does not happen ? Regards Eriovaldo 2009/1/21 Jose C Carvalho <jccarva...@cps.pst.com.br> > > Hello Mr Andrietta , I've quick google the Erro and got ... This typically > happens if there is infinite recursion in the PL/SQL function that is being > executed you should alter the recursion condition in order to prevent > infinite recursion. > > There is no "obvious" recursion in my code. > > > > JOSÉ CARLITOS CARVALHO JÚNIOR > Administrador de Banco de Dados > > PST Eletrônica S/A > (+55 (19) 3787-6418 > Ê+55 (19) 3787-6238 > / jccarva...@pst.com.br <jccarvalho%40pst.com.br> > web:http://www.pst.com.br > web:http://www.positron.com.br > > (Embedded image moved to file: pic18467.jpg) > > From: Eriovaldo Andrietta <ecandrie...@gmail.com <ecandrietta%40gmail.com>> > > > To: oracle_br@yahoogrupos.com.br <oracle_br%40yahoogrupos.com.br> > > Date: 21/01/2009 10:38 > > Subject: [SPAM]:[oracle_br] ORACLE SPATIAL - Error - > > > Hi friends, > > We are getting the following error when using Oracle Spatial. > > ORA-21780: Maximum number of object durations exceeded > > We tried to reduce the database, without sucess. We are doing SDO_JOIN > using 2 tables - ULTIPOLYGON one with 2197 lines versus 7543 lines. > > Strange is that the errors occurs in different times, and not in the same > point. It seems that Oracle became tired after some time and break the > process. > We are using workarea_size_policy string AUTO and enough PGA. > > What is wrong with the SDO_JOIN ? > Why does it happen ? > > Regards > Eriovaldo > > [As partes desta mensagem que não continham texto foram removidas] > > > > > > [As partes desta mensagem que não continham texto foram removidas] > > > [As partes desta mensagem que não continham texto foram removidas]