Oracle Database Adapter - SQL Issue
SummaryIssue while trying to create a SQL query
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