Skip to Main Content

General Development Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Validate sql query in OIC

User_P09IFJun 8 2023

When I develop integration in oic,I config the sybase db connection,it always show the follow error message。

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 theWelcome page. Refer Oracle documentation for further information.

if I remove the parameter “#” will be success.

eg:

“select * from dbo.f_vw_cn_contract_fund ” is success

“select * from dbo.f_vw_cn_contract_fund where staff_id=#personnumber” is Error.

I don't have this problem when using other databases connection.

Comments

Dwayne Miller Jan 14 2025

FYI… the stack trace shows this method as the one responsible for the exception, but not sure how it is trying to determine the local offset.

Oracle.DataAccess.Types.TimeStamp.GetLocalTZOffset()

1 - 1

Post Details

Added on Jun 8 2023
1 comment
716 views