June 5, 2015 at 7:18 am
I have a specific need in which I need to convert BLOB data to VARBINARY.
When I execute below statement, it gives me error - "ORA-000907: missing right parenthesis" whereas it can be seen that both the opening parenthesis are closed.
select cast(ImgTable.ImageBLOB as varbinary(max)) from ImgTable
What can be the problem? And how to handle this?
July 7, 2015 at 2:21 pm
SAMDEV (6/5/2015)
I have a specific need in which I need to convert BLOB data to VARBINARY.When I execute below statement, it gives me error - "ORA-000907: missing right parenthesis" whereas it can be seen that both the opening parenthesis are closed.
select cast(ImgTable.ImageBLOB as varbinary(max)) from ImgTable
What can be the problem? And how to handle this?
As this error is coming from Oracle, I'm guessing the "varbinary(max)" data type might be the problem. I'm not sure if Oracle supports that data type. Check the Oracle data type documentation.
Steve (aka sgmunson)
Rent Servers for Income (picks and shovels strategy)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy