InterMedia: Can I?

[dbasan]

1. I need to modify a column A which is LONGRAW to BLOB for Intermedia.

2. resize the image in a table to the custom length, height for intermedia. If so how?

[tamilselvan]

Did you try TO_LOB fn provided by Oracle?

Tamil

[dbasan]

Thanks, Tamil i was scrutinising the DBMS_LOB package. If you can post the TO_LOB fn code, me as well others can use them.

2. Looking for a clue on resizing the image in a table?

[tamilselvan]

Thanks, Tamil i was scrutinising the DBMS_LOB package. If you can post the TO_LOB fn code, me as well others can use them.

2. Looking for a clue on resizing the image in a table?

1. TO_LOB is used for conversion from LONG/LONG RAW to CLOB/BLOB.

2. You cannot resize an image (LOGNRAW) using this function.

Tamil

[dbasan]

1. TO_LOB is used for conversion from LONG/LONG RAW to CLOB/BLOB.

2. You cannot resize an image (LOGNRAW) using this function.

Tamil

1. You can use the same for DBMS_LOB.

2. You can do it with CLOB, right! and ?

[tamilselvan]

If you want erase /delete part of image data, then use dbms_lob.erase procedure.

But my question is how do you konw upto which part of the binary data you want to delete?

Tamil

[dbasan]

If you want erase /delete part of image data, then use dbms_lob.erase procedure.

But my question is how do you konw upto which part of the binary data you want to delete?

Tamil

I think you can't either delete/erase part of the image as you can only resize the image based on width/ height or pixels.
Or

You can erase/delete the unwanted portion in a photo editing tool and load the image as external file (BFILE/BLOB) into the table using intermedia(if its a single or less number of files.

Update:
1. TO_LOB took less than 5 mins to convert 1000 images than the DBMS_LOB package.