Re: interesting dynamic pl/sql question

2003-10-09 Thread AK
I think ' begin > mystorageArray.field_''i'' := 1; > end; '; will not recongize mystoragearray as a variable . -ak - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, October 09, 2003 11:49 AM > Im on 8.1.7. Is it possible to do

RE: interesting dynamic pl/sql question

2003-10-09 Thread Jamadagni, Rajendra
Title: RE: interesting dynamic pl/sql question Ryan, what errors are you getting? Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can

RE: interesting dynamic pl/sql question

2003-10-09 Thread Igor Neyman
You should be getting errors, because PL/SQL inside "execute immediate" knows nothing about "mystorageArray" (or "i" for that matter) declared in your stored procedure. Probably, you could get by using "package" variables (and referring to them properly: package_name.var_name, specifically inside y