Home » SQL & PL/SQL » SQL & PL/SQL » Offset Value of a image (Oracle10g R2)
Offset Value of a image [message #433932] Sat, 05 December 2009 03:03 Go to next message
tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka
Senior Member
How to get OffsetImageValue from a image which is stored blob column ?
Re: Offset Value of a image [message #433936 is a reply to message #433932] Sat, 05 December 2009 03:15 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
What is OffsetImageValue?
Re: Offset Value of a image [message #433962 is a reply to message #433932] Sat, 05 December 2009 14:22 Go to previous messageGo to next message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
I found this, not sure if it is relevant.

To my knowledge, Oracle does not offer this so you will have to build your own C program, or plsql program to do it.

Alterntatively I note that you did not ask for OFFSET IMAGE VALUE but rather you asked for OffsetImageValue. This looks like a function call in some language somewhere. If so you can investigate where the library code for this is (DLL IN WINDOWS) and then write a plsql wrapper to the library and call it directly from plsql in a number of ways. I figure that is your best bet.

Good luck with that one. Kevin

[Updated on: Sat, 05 December 2009 14:23]

Report message to a moderator

Re: Offset Value of a image [message #434092 is a reply to message #433932] Mon, 07 December 2009 02:58 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
I strongly suspect that you won't get this value without writing some code to calculate it.

Oracle has no knowledge about, or interest in the data that is stored in a BLOB. It could be an image, it could be a document, it could be 3gb of random 1s and 0s.
Oracle provides you with functions to search and retrieve the data, but that's it.
Previous Topic: Paging in pl/sql (merged)
Next Topic: Select the row if atleast 1 column = 0
Goto Forum:
  


Current Time: Mon Feb 17 05:09:10 CST 2025