RE: PL/SQL - FORALL statement

Hi,

I think Execute Immediate is not directly supported for bulk binds...so you
may give a try without  this..

 
FOR v_Count IN pDPSQL.first..pDPSQL.last
loop
EXECUTE IMMEDIATE pDPSQL(v_Count);
end loop;

Regards
Elango 




-----Original Message-----
From: [email protected] [mailto:[email protected]]
Sent: 15 January 2003 04:23
To: Oracle
Subject: [oracle] PL/SQL - FORALL statement


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.unsub%%.


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