How to edit BLOB using Toad

eslami · September 29, 2015, 7:06am

Dear Community,

Few years ago, when I was using the very old version of Toad, I was able to modify the BLOB columns through Toad.

Now I don’t see any option to do so. (I am using the very latest version 12.7)

Your help is highly appreciated.

Best Regards

Arsalan

JohnDorlon · September 29, 2015, 7:12am

In the data grid, just double-click the cell of the row/column that you want to edit. That will open a dialog where you can upload a file to the BLOB column.

You can also rt-click in the cell and choose “popup editor”.

These options are only available when the query that populates the grid includes ROWID as one of the columns.

eslami · September 29, 2015, 8:02am

Dear John,

Thanks for your reply.

It seems that I am missing some settings, because I can’t see the query which is save inside the BLOB.

There is a query saved in BLOB and I am not able to see and/or edit it.

This is the Hex data view:

Previously I was able to open the BLOB using Toad and paste my query inside this field.

This is what I have lost and would like to remember how to do so.

Best

Arsalan

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Tuesday, September 29, 2015 8:14 AM

To: toadoracle@toadworld.com

Subject: RE: [Toad for Oracle - Discussion Forum] How to edit BLOB using Toad

RE: How to edit BLOB using Toad

Reply by John Dorlon

In the data grid, just double-click the cell of the row/column that you want to edit. That will open a dialog where you can upload a file to the BLOB column.

You can also rt-click in the cell and choose “popup editor”.

These options are only available when the query that populates the grid includes ROWID as one of the columns.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.

JohnDorlon · September 29, 2015, 8:16am

Your images didn’t come though, but what I meant is, do something like this in the Editor:

Select T.ROWID, T.*

from my_table_with_blob T

Run that with F9, and then you should be able to double-click in the cells to edit your BLOB.

I am not sure what you mean by “query which is save inside the BLOB”. But if you are storing text in the BLOB column then I’ll say this: BLOBs are meant for Binary data. If you are putting text/Character data in this field, it would be better to use CLOB.

eslami · September 29, 2015, 8:33am

Thanks John.

I think what I used to do, was to edit CLOB and not BLOB.

Sorry for confusion.