ORA-00936 Missing Expression With SSIS Execute Script Task

  • Andy Hyslop

    SSCrazy Eights

    Points: 9198

    Just wanted to post this in case someone else feels my pain.

    I've been working with Oracle and SSIS recently, I wrote a delete statement within Developer that worked perfectly, pasted the SQL into an SSIS Execute SQL Task and again

    it parsed successfully however once I ran the package it failed with the above error!

    After multiple re-writes of the query trying to figure out the Oracle syntax for this delete statement I finally found the following

    http://thefirstsql.com/2012/09/28/ora-00936/

    So credit where its due this saved me hours more work and debugging, apparently you cannot use -- to comment your scripts in SSIS when using Oracle

    I hope this helps someone else

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

  • PaulB-TheOneAndOnly

    SSC Guru

    Points: 66773

    Thank you for the posting Andy. I'm sure it will help a number of people down the road, Thank you for sharing.

    _____________________________________
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at Amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
  • yamillahuatzin

    SSC Enthusiast

    Points: 157

    You save my day bro!!! Thanks

  • Andy Hyslop

    SSCrazy Eights

    Points: 9198

    Glad it helped 😀

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

  • jaytaylor_it

    SSC Journeyman

    Points: 83

    You saved me with your observation on "--" for commenting. Thanks. Who would have thought?

  • Andy Hyslop

    SSCrazy Eights

    Points: 9198

    Glad its helping people 🙂

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

Viewing 6 posts - 1 through 6 (of 6 total)

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