Skip to Main Content

ORDS, SODA & JSON in the Database

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!

PLSQL Table and ORDS

VikasShOct 15 2018 — edited Oct 16 2018

Hi,

Does anyone know how we use PLSQL table with ORDS. when using 11gR2 database. I tried creating a REST service PL/SQL block based and wrote a package procedure with PL/SQL table (array) one parameter.when i call it in REST handler i get error wrong type argument.

Following is the code. Help me to find the error. I have read that PLSQL index by integer table are supported.

REST handler

pastedImage_0.png

Package

pastedImage_1.png

pastedImage_2.png

Error

java.sql.SQLException: ORA-06550: line 3, column 4:

PLS-00306: wrong number or types of arguments in call to 'INS_C'

ORA-06550: line 3, column 4:

PL/SQL: Statement ignored

Table:

pastedImage_8.png

Comments
Post Details
Added on Oct 15 2018
4 comments
475 views