Hi Avi
This is the problem actually...
(1)
CREATE OR REPLACE PACKAGE types AS
TYPE cursorType IS REF CURSOR;
END;
create or replace procedure...(.... , rsDet OUT types.cursorTypes)
OPEN rsDet FOR
select C.UID, S.MDF_NO , F.COM_NO
from cust_rec c,sub_data s,fault f
where c.exchange_code = exg
and s.uid= c.uid...[FOR UPDATE?];
update fault set curr_stage = 'abc'
where com_no = <???> ;
end <proc name>;
The problem is in the UPDATE stmt, - the where condition....I want to
update fault table using the value of com_no obtained from the select
statement above. How can u use the value of com_no from the above
select statement?...and then return the resultset?.
(2)
How do you then read from a nested table using JDBC?.
Suppose i have two tables..
tab1
com_no vc(4)
lm_code lm1_nt
lm1_nt (nested table)
si_no number
lm_code vc(5)
lm_date sysdate
tab2
com_no vc(4)
name vc(50)
one of the fields in tab1 is a nested column(lm_code).
At first i will be inserting a record into
tab1, but will not be inserting any data into the nested field(lm_code
would be null). Only in a subsequent updation of tab1, will i be
entering value into the nested field.
How do u insert values into this nested table in that case?
When i try to insert a value using
'Insert into THE (select lm_code from fault
where lm_code is null) values (LM1_TY(1,'2232',SYSDATE))
i am getting the erros msg...
where lm_code is null) values (LM1_TY(1,'2232',SYSDATE))
*
ERROR at line 2:
ORA-22908: reference to NULL table value
(3)
How to get the name and
the two records last entered in the nested table for a particular
com_no along with the resultset?. Would varray be a better option
here?
How to query and then how do you read it in the Java program using JDBC?
Thanks
csb
