Re: Oracle stored procedure call ...

2011-09-23 Thread Garrison, Sean (Norcross)
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

Re: Oracle stored procedure call ...

2011-09-23 Thread Cecil, Ken
To: arslist@ARSLIST.ORG Subject: Re: Oracle stored procedure call ... ** call probably works in MS SQL but doesn't work for Oracle. Execute works if you run it via SQLPlus but doesn't work in a filter. From what I can tell you must have a begin and end (for oracle) and it must be on one line. Just

Re: Oracle stored procedure call ...

2011-09-23 Thread Garrison, Sean (Norcross)
discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Cecil, Ken Sent: Friday, September 23, 2011 10:03 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle stored procedure call ... ** Call is portable and works for both Oracle and Microsoft for me. Here is the language reference

Re: Oracle stored procedure call ...

2011-09-23 Thread Bennett, Craig
] On Behalf Of Garrison, Sean (Norcross) Sent: Friday, September 23, 2011 10:37 AM To: arslist@ARSLIST.ORG Subject: Re: Oracle stored procedure call ... ** I get this ARERR [552] Failure during SQL operation to the database : ORA-00911: invalid character when I do the following: {CALL Test_SP2

Re: Oracle stored procedure call ...

2011-09-23 Thread Grooms, Frederick W
To: arslist@ARSLIST.ORG Subject: Re: Oracle stored procedure call ... ** Call is portable and works for both Oracle and Microsoft for me. Here is the language reference for each in case you want to try it. http://download.oracle.com/docs/cd/E11882_01/server.112/e17118/statements_4008.htm#i2119950

Oracle stored procedure call ...

2011-09-22 Thread Garrison, Sean (Norcross)
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

Re: Oracle stored procedure call ...

2011-09-22 Thread Cecil, Ken
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