You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Oracle Database Adapter - SQL Issue

Received Response
8
Views
2
Comments
edited Dec 8, 2020 3:37PM in Integration 2 comments

Summary

Issue while trying to create a SQL query

Content

Hello guys, i'm trying to implement a simple query as code snippet but i'm receiving the following error:

Error: Unable to create the request and response data definition for this SQL Query. Please fix the SQL Statement or try to switch to Perform table operation option on the Welcome page. Refer Oracle documentation for further information.

Any inputs on how to solve this? Whitout those to_date functions the query works on my database but not in OIC, it keeps returning "Not a valid month".

I've also tried to create this as a procedure returning out sys_refcursor but i'm not aware on how to map the coluns after that, any inputs also?p

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!