Skip to Main Content

SQL Developer

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.

Ordinal binding and Named binding cannot be combined

netfoxDec 3 2024 — edited Dec 25 2024

Dear All,

I am facing following error when tried to add a new record

INSERT INTO "SERVICES2"."JRXML_REPORT_IMAGES" (JRI_ID, JRI_NAME, JRI_IMAGE) VALUES ('7258', 'testt.jpg', empty_blob())
UPDATE "SERVICES2"."JRXML_REPORT_IMAGES" SET JRI_IMAGE=? WHERE ROWID=:sqldevrowid AND ORA_ROWSCN=:sqldevrowscn
ORA-17090: Operation not allowed: Ordinal binding and Named binding cannot be combined!
https://docs.oracle.com/error-help/db/ora-17090/

One error saving changes to table "SERVICES2"."JRXML_REPORT_IMAGES":
Row 212: ORA-17090: Operation not allowed: Ordinal binding and Named binding cannot be combined!
https://docs.oracle.com/error-help/db/ora-17090/

Working fine on 23 version, any input highly appreciated.

Comments
Post Details
Added on Dec 3 2024
1 comment
115 views