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 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> To: oracle_br@yahoogrupos.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]