xml / xsql problem leads to 0ra-0600

About a week ago I wrote about problems we encountered during development when
an xsql page does an insert, insert fires a trigger, trigger calls procedure to process
data, xsql page does a select from output table to return We had 2 problems:
1) ORA-00600: internal error code, arguments: [qmxsqLoadNS], [], [], [], [], [], [], [] Current SQL statement for this session: 2) Output came not beyond a certain limit

Problem 1 is recognized as bug by Oracle Support in 9.2.0.4, 9.2.05 and 9.2.0.6 Solved in 10.2 Unknown what is fixed Bug is described in 3872147 . I'm still trying to convince them to do something about it because in 3 weeks we have go live with this software and my alert is full with this ora-0600 Bug is definitely caused by the trigger  

Problem 2 is solved, this was caused by getting output through a xmltype column which in xsql relates to
a plsql string with size limitation on 64k

Regards,

Jeroen

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/