| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Reference Uninitialized composite problem again
Niall Litchfield wrote:
>
> 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
Here is the part of procedure from ASP page:
voPak = "{call IPV$vd2_order.GetOrder(?, {resultset 90000, o_order_id, o_order_type," &_
" o_purchaseTy, o_vendorID, o_order_source, o_fsc, o_niin, o_partNum," &_
" o_loc_id, o_req_num, o_po_id, o_po_date, o_status, o_orderDate," &_
" o_directPO, o_errorMsg, o_linkReq, o_detail, o_priceStatus," &_
" o_qty, o_ui, o_rcvdQty, o_rcvdUI })}"
'This code creates a command object.
Set cmdStoredProc = Server.CreateObject("ADODB.Command")
cmdStoredProc.ActiveConnection = cnVO
cmdStoredProc.CommandText = voPak
cmdStoredProc.CommandType = adCmdText
cmdStoredProc.Parameters.Refresh
cmdStoredProc(0) = Session("voSql")
here is my procedure part:
PROCEDURE GetOrder (p_condStr IN VARCHAR2,
o_order_id IN OUT tbl_order_id,
o_order_type IN OUT tbl_order_type,
o_purchaseTy IN OUT tbl_purchaseTy,
o_vendorID IN OUT tbl_vendorID,
o_order_source IN OUT tbl_order_source,
o_fsc IN OUT tbl_fsc,
o_niin IN OUT tbl_niin,
o_partNum IN OUT tbl_partNum,
o_loc_id IN OUT tbl_loc_id,
o_req_num IN OUT tbl_req_num,
o_po_id IN OUT tbl_po_id,
o_po_date IN OUT tbl_po_date,
o_status IN OUT tbl_orderStatus,
o_orderDate IN OUT tbl_orderDate,
o_directPO IN OUT tbl_directPOFlag,
o_errorMsg IN OUT tbl_errorMsg,
o_linkReq IN OUT tbl_linkReq,
o_detail IN OUT tbl_detail,
o_priceStatus IN OUT tbl_priceStatus,
o_qty IN OUT tbl_rcvdQty,
o_ui IN OUT tbl_qtyUnit,
o_rcvdQty IN OUT tbl_rcvdQty,
o_rcvdUI IN OUT tbl_qtyUnit ) IS
-- local variables to build sql statement and where clause
v_sqlStmt VARCHAR2(3000);
v_count BINARY_INTEGER DEFAULT 1;
v_order_id purchase_requests.order_id%TYPE;
v_order_type purchase_requests.order_type%TYPE;
v_purchaseTy purchase_requests.purchase_type%TYPE;
v_vendorID purchase_requests.vendor_id%TYPE;
v_order_source purchase_requests.order_source%TYPE;
v_fsc purchase_requests.fsc%TYPE;
v_niin purchase_requests.niin%TYPE;
v_partNum purchase_requests.part_number%TYPE;
v_loc_id purchase_requests.loc_id%TYPE;
v_req_num purchase_requests.req_num%TYPE;
v_po_id po_lines.po_id%TYPE;
v_po_date po_heads.po_date%TYPE;
v_errorMsg purchase_requests.error_msg%TYPE;
v_status po_lines.pol_status%TYPE;
v_orderDate purchase_requests.order_date%TYPE;
v_priceStatus purchase_requests.price_status%TYPE;
v_directPO purchase_requests.isDirectPO%TYPE;
v_detail VARCHAR2(1);
v_linkReq VARCHAR2(2);
v_po_line po_lines.po_line%TYPE;
v_qty po_lines.qty%TYPE;
v_rcvdQty receipts.qty%TYPE;
v_ui po_lines.qty_unit%TYPE;
v_rcvdUI receipts.qty_unit%TYPE;
v_sumQty receipts.qty%TYPE;
BEGIN ...
EXIT WHEN v_cursor%NOTFOUND;
END GetOrder;
Thanks Received on Tue Aug 21 2001 - 22:45:48 CDT
 |
 |