Skip to Main Content
Forums

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!

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.

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