When I try to execute a store procedure in Oracle I get an error. When I execute the same procedure in SQLDeveloper it completes without error. It seems like is an error due to the ADS Query Analyzer(?) Does anyone have the solution to this or an advice of how to execute a store procedure in a way that will work in both tools (SQLDeveloper and ADS)?
Thank You
Response
Thomas Conrad over 4 years ago
Hi jjsai,
I am guessing that it is tripping over the square box character at the end of that line.
Thanks, Tom
jjsai over 4 years ago in reply to Thomas Conrad
Thank you for your reply. The issue is the ‘;’ Separator in the general options. Once I deselect this one I was able to execute by using: BEGIN PROCEDURE(); END; GO