Re: Cursor Value to Delimited String Variable??
From: LKBrwn_DBA <member30625_at_dbforums.com>
Date: Thu, 04 Sep 2003 17:45:22 -0400
Message-ID: <3332173.1062711922_at_dbforums.com>
Date: Thu, 04 Sep 2003 17:45:22 -0400
Message-ID: <3332173.1062711922_at_dbforums.com>
Too many 'declares'!
DECLARE
s_AppSubType VarChar2(255);
x VarChar2(255);
y VarChar2(255);
CURSOR ApplicationFor IS
SELECT InfoDesc
FROM tbl1, tbl2
WHERE tbl1.folderrsn = argFolderRSN
AND tbl1.infocode = tbl2.infocode;
BEGIN
FOR ApplicationFor_cur IN ApplicationFor LOOP
x := x ||', '|| ApplicationFor_cur.InfoDesc;
END LOOP;
s_AppSubType := x;
..
END:
/
:cool:
-- Posted via http://dbforums.comReceived on Thu Sep 04 2003 - 23:45:22 CEST