Doesn't this work and do what you want or is there more to it than that?
call TEST_SP2; Ken. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Garrison, Sean (Norcross) Sent: Thursday, September 22, 2011 5:23 PM To: [email protected] Subject: Oracle stored procedure call ... ** This is kind of weird but I have been debugging why an oracle stored procedure call wasn't working for me. We created a simple stored procedure called "TEST_SP2" and it would not work. What we found was you had to put it all on one line: declare begin TEST_SP2; end; This did not work: Declare Begin TEST_SP2; end; Anyone notice similar behavior? It used to work that way in 7.0.1 but I might be mistaken. We are currently on 7.5 patch 6. Do I need to do something different? Thanks, Sean _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ******************************************************************* This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept for the presence of computer viruses. www.Hubbell.com - Hubbell Incorporated** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
