"Missing parenthesis" error while casting data to VARBINARY in Oracle

• SAMDEV

  SSC-Addicted

  Points: 494

  More actions

  June 5, 2015 at 7:18 am

  #398548

  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?

• sgmunson

  SSC Guru

  Points: 110644

  More actions

  July 7, 2015 at 2:21 pm

  #1810808

  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)