From starsoft@interware.hu Sat, 22 Sep 2001 06:17:46 -0700 From: Csillag Zsolt Date: Sat, 22 Sep 2001 06:17:46 -0700 Subject: RE: Bulk collect error Message-ID: MIME-Version: 1.0 Content-Type: text/plain Hi, Type T_FofejezetNev_Table IS TABLE OF Fofejezet.Fofejezet_Megnevezes_Magyar%Type INDEX BY BINARY_INTEGER; Type T_FofejezetKod_Table IS TABLE OF Fofejezet.Fofejezet_Azonosito2%Type INDEX BY BINARY_INTEGER; Type T_SzamTomb IS TABLE OF Pls_integer INDEX BY BINARY_INTEGER; TYPE T_FOFEJEZET IS RECORD ( FoFejezetNev T_FofejezetNev_Table, FoFejezetKod T_FofejezetKod_Table, Darab T_SzamTomb ); Vissza T_FOFEJEZET ; And the code I can't complile : 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 ; When I want to compile I get PLS-00103 error. At 11:10 2001.09.20. -0800, you wrote: >What is the definition for Vissza.FoFejezetNev and Vissza.FoFejezetKod and >Vissza.Darab ?? > >Raj >______________________________________________________ >Rajendra Jamadagni MIS, ESPN Inc. >Rajendra dot Jamadagni at ESPN dot com >Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. > Zsolt Csillag Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: starsoft@interware.hu 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: ListGuru@fatcity.com (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).