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.