Re: Call to mysql procedure fails with error.
Thanks for that Peter. I did changed ' to " and it worked like a charm. Do I have to still use PREPARE statement ? also is that best practice?
From:
myvar=$(mysql -q mydb -uuser --skip-column-names --execute='call delete_table_incrementally(batchsize)')
To:
myvar=$(mysql -q mydb -uuser --skip-column-names --execute="call delete_table_incrementally(batchsize)")
Waiting for your advice.
Thanks
Subject
Written By
Posted
November 21, 2016 03:17AM
November 21, 2016 05:37AM
November 21, 2016 11:41AM
Re: Call to mysql procedure fails with error.
November 22, 2016 09:18AM
November 22, 2016 01:58PM
November 22, 2016 06:26PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.