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

SunilD

Did you resolve this issue? If yes, could you please help me with your fix?

1 - 1

Post Details

Added on Jun 8 2023
1 comment
784 views