Hi,
The following statment works perfectly:
Select F.Fofejezet_Megnevezes_Magyar,F.FOFEJEZET_AZONOSITO2,
(Select Count(*) from alfejezet where
alfejezet.ALFEJEZET_FOFEJEZET_AZONOSITO2= F.Fofejezet_Azonosito2)
From Fofejezet F ;
However when I put this very same statement into a Pl/Sql procedure with
Bulk Collect,
I get PLS-00103 error:
Select F.Fofejezet_Megnevezes_Magyar,F.FOFEJEZET_AZONOSITO2,
(Select Count(*) from alfejezet where
alfejezet.ALFEJEZET_FOFEJEZET_AZONOSITO2= F.Fofejezet_Azonosito2)
Bulk Collect Into Vissza.FoFejezetNev,Vissza.FoFejezetKod,Vissza.Darab
From Fofejezet F ;
Can somebody help me?
Thank you
Zsolt Csillag
Hungary
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Csillag Zsolt
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).