Inedo Community Forums Forums
    • Recent
    • Tags
    • Popular
    • Login

    Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.

    If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!

    Oracle database script error

    Scheduled Pinned Locked Moved Support
    oracledatabasesbuildmaster
    3 Posts 1 Posters 10 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • ? This user is from outside of this forum
      Guest
      last edited by

      I am trying to run a simple script in Oracle using BuildMaster. It is a one-line script that runs in SQLPlus and drops a table.

      drop table t;

      When I run it in BuildMaster, it returns and ORA-00911 error, invalid character.

      If I remove the semicolon from the script, it runs OK in buildmaster.

      We are in the process of purchasing the BuildMaster tool, but if it is not able to run our existing Oracle scripts, we can't use it for out database deployments.

      Please let me know if there is a parameter I need to change or if BuildMaster is not able to run scripts with a semi-colon.

      Thanks,
      John Johnson
      Director Database Services
      RGA

      1 Reply Last reply Reply Quote 0
      • ? This user is from outside of this forum
        Guest
        last edited by

        Currently the provider supports a single command. We will update the provider and release a new version of it that supports the semicolon.

        One of our engineers will post in this thread once the extension is released.

        1 Reply Last reply Reply Quote 0
        • ? This user is from outside of this forum
          Guest
          last edited by

          This has been updated; Oracle Extension 3.1 now supports multiple commands per script.

          You can update this from within BuildMaster

          1 Reply Last reply Reply Quote 0

          Hello! It looks like you're interested in this conversation, but you don't have an account yet.

          Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

          With your input, this post could be even better 💗

          Register Login
          • 1 / 1
          • First post
            Last post
          Inedo Website Home • Support Home • Code of Conduct • Forums Guide • Documentation