Skip to Main Content

APEX

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!

APEX 20.2Rest DataSource Out Parameter in POST giving Error:ORA-06592:CASE not found while executing

VikasShApr 23 2021

Hi,
I created a rest data source for a ORDS based web service. Which has a out parameter vrno (Header) as string it returns a id after Insert a row in the database.
Rest Datasource works fine with GET and POST. But when i add a out parameter in POST to get the return value of vrno it give following

: ORA-06592: CASE not found while executing CASE statement

I would like to display this value in the form after successful POST call. following are the details
Column in Data Profile
image.pngPOST parameter
image.pngItem in Form bind to vrno
image.pngParameter Defined in ORDS
image.png
Many Thanks in advance.
Vikas

This post has been answered by Carsten Czarski-Oracle on Apr 26 2021
Jump to Answer
Comments
Post Details
Added on Apr 23 2021
8 comments
693 views