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!

Using Strings (Array) in Oracle Procedure plsql

Afzal BaigMay 15 2023 — edited May 15 2023

Dear All,

Database: 19

We receive Strings(Array) of values from C# into Oracle procedure.

Ex:

items = {'item1','item2','item3'}

Amount = {100,200,300}

Request plsql block to dbms_output as below.

1- item1-100

2-item2-200

3-item3-300

Regards,

Afzal.

Comments
Post Details
Added on May 15 2023
9 comments
1,347 views