Home Forums SQL Server 2008 Working with Oracle "Missing parenthesis" error while casting data to VARBINARY in Oracle RE: "Missing parenthesis" error while casting data to VARBINARY in Oracle

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