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!

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
818 views