PL/SQL - FORALL statement

[email protected] Wed, 15 Jan 2003 00:23:28

Newsgroups	gmane.comp.db.oracle.devel
Message-ID	<LYRIS-1796914-833337-2003.01.15-00.10.15--gcdod-oracle#[email protected]>

Hi All!
 
I am trying to send all my dynamic sqls for execution in SQL engine from 
my PLSQL stored procedure but get error "PLS-00103: Encountered the 
symbol "EXECUTE" when expecting one of the following:
 
   . ( * @ % & - + / at mod rem select update <an exponent (**)>
   delete insert ||" 
 
the code I use in the stored proc is as:
 
FORALL v_Count IN pDPSQL.first..pDPSQL.last

EXECUTE IMMEDIATE pDPSQL(v_Count);

 

Please help or suggest a better way of sending all sqls in one block to 
sql engine for execution.

Thank you.

Regards,

 

Sam R
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].