José, It is a good idea. I will do it. The version is:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod PL/SQL Release 10.2.0.4.0 - Production CORE 10.2.0.4.0 Production TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production On Wed, Jan 21, 2009 at 12:20 PM, Jose C Carvalho <jccarva...@cps.pst.com.br > wrote: > > Why don't you open an SR and escalate it to ensure that you get an answer ? > > Maybe It's a Bug .!!! What's the DB Version ? > > Rgs > > 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: pic27348.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 11:08 > > Subject: Re: [SPAM]:[oracle_br] ORACLE SPATIAL - Error - > > > 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<jccarvalho%40cps.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> <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<%3Fecandrietta%40gmail.com><ecandrietta% > 40gmail.com>> > > > > > > To: oracle_br@yahoogrupos.com.br <oracle_br%40yahoogrupos.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] > > > > > > [As partes desta mensagem que não continham texto foram removidas] > > > [As partes desta mensagem que não continham texto foram removidas]