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!

How to pass sql string into Handler of Collection Query

Sasha GomanukeJul 22 2020 — edited Jul 22 2020

Hi, guys.

I'm just investigating a possibilities of ORDS to plan a development.

Look, It's not a problem to pass sql-string into Handler with source type PL/SQL and get back a result of executed query by means of htp.p.

Can i pass sql-string into Handler with type Collection Query to avoid PL/SQL?

Trying to use bind variable as sql in Collection Query leads to error:

The request could not be processed because an error occurred whilst attempting to evaluate the SQL statement associated with this resource. Please check the SQL statement is correctly formed and executes without error. SQL Error Code: 17439, Error Message: Invalide type SQL: sqlKind = UNINITIALIZED

Appreciate You.

This post has been answered by EJ-Egyed on Jul 22 2020
Jump to Answer

Comments

Processing

Post Details

Added on Jul 22 2020
5 comments
694 views