Re: Reference Uninitialized composite problem again

not a good day yesterday for me apparently.

running out of memory was what I intended to say.

The error is an Oracle error so It may be caused by a stored procedure if you are running any of those, or by the code send from your asp page. Can you post the web page code to start with?

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"C Chang" <cschang_at_maxinter.net> wrote in message
news:3B81CBFD.190D_at_maxinter.net...


> Niall Litchfield wrote:

> >

> > From the docs

> >

> > ORA-06530: reference to uninitialized composite

> >

> > Cause: An object, LOB, or other composite was referenced as a left hand

side


> > without having been initialized.

> >

> > Action: Initialize the composite with an appropriate constructor or

> > whole-object assignment.

> >

> > In other words it looks like your code is not correctly initialising

your


> > objects, or perhaps you are running out

> >

> > --

> > Niall Litchfield

> > Oracle DBA

> > Audit Commission UK

> >

> > C Chang" <cschang_at_maxinter.net> wrote in message

> > news:3B7DF45F.622_at_maxinter.net...

> >

> > > Niall Litchfield wrote:

> > > >

> > > > Could you post (or repost) your problem description. I for one don't

> > have a

> > > > clue because you don't actually state your issue.

> > > >

> > > > --

> > > > Niall Litchfield

> > > > Oracle DBA

> > > > Audit Commission UK

> > > > "C Chang" <cschang_at_maxinter.net> wrote in message

> > > > news:3B7B46A1.4743_at_maxinter.net...

> > > > > We recently moved out oracle 8.1.6 DB server from an one CPU

compaq


> > > > > machine to a two CPUs  DEll machine.  However this problem appears

> > more

> > > > > often right. The IIS Web server is on NT4 using the MS ODBC.  The

> > > > > problem appeared when we tried to search a lot number of record

> >  return

> > > > > like 2000 rows of records ).  Even we have initialized all the

return


> > > > > parameters from oracle procedure to null.  The problem seems

> > > > > persistent.  Does Anyone have any clue?  Thanks ahead.

> > > > >

> > > > > C Chang

> > > Sorry for the confusion. My problem is That I have a web page submit

> > > several criteria to search record from ORacle DB.  When I press

submit,


> > > I occasionally got an error "Reference of Uninitialized Composite.."

> > > from ORacle Server.  It did not happen every time. It happen more

often


> > > on my new 2 CPU Dell server.

> > >

> > > C Chang

> Which object that I did not properly initialize?  Is it on Oracle DB

> side or the parameters from the ASP ( web Server) side?  could you

> kindly give an example of a proper contructor?  What am I running out?

> Thanks again.

>


> C Chang