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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
539 views