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
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
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
Im on 8.1.7. Is it possible to do something like this? Im getting errors:
create or replace procedure myproc is
TYPE myRecord is RECORD (
field_1 number,
field_2 number);
TYPE storageArray IS TABLE OF myRecord
INDEX BY BINARY_INTEGER;
myStorageArray storageArray;
i number