Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to pass a variable with index(i) into a Procedure?

Jasper TanglibApr 7 2021

Hi,
In PLSQL, my code (please refer below) will assign a ZIP file into variable l_files(type is apex_zip.t_files). I then have a loop(i) that stores the ZIP file contents into l_files(i). And this l_files(i) is what I insert into my column.
image.png
I want the code above to look like this. It will call a procedure like ZIP_FEATURE_USAGE_STATISTICS.
image.png
My Procedure ZIP_FEATURE_USAGE_STATISTICS currently looks like this but it displays the error below.
image.pngI tried declaring the variable i that's in l_files(i) to remove the error but it does not work as well.
image.png
How do I pass the variable with an index into my Procedure such that the i index in the procedure should hold the value coming from l_files(i)?

Any idea or suggestion is appreciated.

-Jazz

Comments
Post Details
Added on Apr 7 2021
9 comments
557 views