Hello dbi users,
I'm trying to convert an oracle pl/sql script to perl dbi using MySQL.
pl/sql(oracle's procedural language
extensions for SQL) uses a data type(table) called an "index-by table".
It gives you an integer index into your result set(once loaded into this
structure) so that your records can be referred to by the sequence in
which they were returned. Example syntax would be --
my_index_by_table[2].last_name -- This would designate the last_name
field in the second record. I hope I'm explaining this well.... The end
result in oracle is that I have the entire result set in memory and can
skip around, back and forth (so-to-speak) through the data. I've used
fetchall_arrayref with a foreach loop in the past with perl/dbi but I
would really love to replicate this same functionality from oracle (boo
boo hisssss).
Any input would be greatly appreciated!
Marty
