how to resize (scale/crop) a jpg image stored in a blob?
667057Jan 13 2010 — edited Jan 13 2010Hello
My problem is that I am using a database over which I have no DBA privilege. it is operated by a third party.
Clients insert rows in a table with a column (BLOB) containing scanned document (JPG).
At night there is a batch job that reads this table and writes into another table with a new blob column with standardized JPG (width and height).
I need to write a pl/sql package that does this job. I can easily read and write and convert all that needs to be converted and validated but when it comes to scaling or croping the image within the blob I don't know how to proceed.
there is DBMS_LOB.COPY which might handle the cropping (how?) but there is no scale...
I have look around for code but all I found requires intermedia which I don't think is installed (I have 10g 10.2)...
any hints will be greatly appreciated
cheers