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.

Uploading BLOB : ora-17090

Filip HuysmansOct 23 2024 — edited Oct 23 2024

Hi everyone,

SQLDeveloper: Version 24.3.0.284
Windows: Windows11 Home
Database: Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - Production

I want to upload a file to a blob column in my table.

Using the wizard in SQLDeveloper, I upload my file:

After a while, I get the following error:

UPDATE "WKSP_PRIVEE"."BLOB_UPLOAD" SET WHERE ROWID = 'AAAbMiAAAAAAHGbAAA' AND ORA_ROWSCN = '41484317348120'
UPDATE "WKSP_PRIVEE"."BLOB_UPLOAD" SET BLOB_CONTENT=? WHERE ROWID=:sqldevrowid AND ORA_ROWSCN=:sqldevrowscn
ORA-17090: Bewerking is niet toegestaan.: Ordinal binding and Named binding cannot be combined!
https://docs.oracle.com/error-help/db/ora-17090/

One error saving changes to table "WKSP_PRIVEE"."BLOB_UPLOAD":
Row 1: ORA-17090: Bewerking is niet toegestaan.: Ordinal binding and Named binding cannot be combined!
https://docs.oracle.com/error-help/db/ora-17090/

Any idea on how to solve this issue?

Thx

This post has been answered by thatJeffSmith-Oracle on Dec 18 2024
Jump to Answer
Comments
Post Details
Added on Oct 23 2024
3 comments
776 views