Geek Answers Handbook

[Oracle / PHP] Is it possible to pass an array to a PL / SQL procedure?

If possible, how should this parameter look in the procedure? And how to pass an array to a procedure?

+5
source share
2 answers

Yes, you can. You need to use oci_bind_array_by_name.

This page has a good example.

+5
source

You can also transfer multiple entries from .NET to Oracle with just one call. You set the ArrayBindCount of the command object to the number of elements you want to pass, and the value of the parameter to an array of values, not just one value. An example is here :

0
source

More articles:


All Articles