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

  • 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?

  • 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 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply