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
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
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
] 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
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
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
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
7 matches
Mail list logo