Nimesh Gala

Greenhorn
+ Follow
since Aug 10, 2001
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Nimesh Gala

Even i am getting the same message.
Also for the FlashCard application, it says "flashcard is null or not an object".
my browser is IE ver 6.00.2462.000
OK,
i think that may do , but can u send me some example code for it, i searched the web, but i didnt get any sample code to help me out.
i am not at all familiar with referece cursors

Originally posted by Gulab Singh:


thank you sir for ur reply,
i have done as said by u, but now one the procedure is executed it will fetch the records and then close the cursur.
there is nothing coming in the recordset.
what i need to do is find some way to store the fetched records in a temporory table and return that table, so that i will get a result set on the another side.
can u help me in this.
i am a total newbie to Oracle and JDBC combination.
i have written a stored procedure that is expected to return multiple rows.
but when i execute it i get only the first row of it.
my procedure is
CREATE OR REPLACE Procedure SPGETOFFERSINGROUP
( parentId IN VARCHAR2)
IS
OFFID tbl_Offer_Level_Master.offer_id%type;
DES tbl_Offer_Group_Details.description%type;
BEGIN
SELECT tbl_Offer_Level_Master.offer_id, tbl_Offer_Group_Details.description
INTO OFFID, DES
FROM tbl_Offer_Level_Master, tbl_Offer_Group_Details
WHERE tbl_Offer_Level_Master.parent_id = tbl_Offer_Group_Details.offer_group_id
AND tbl_Offer_Level_Master.parent_id=parentId;

END;
this returns only the first record matching the crieteria,
how will i get all the rows?, do i have to use cursors, if so how?
what code is expected to be written in java to get the multiple records.

[This message has been edited by Nimesh Gala (edited August 11, 2001).]