- Joined
- Jan 20, 2009
- Messages
- 21,122
- Likes received
- 773
- Thanks received
- 222
- Location
- Clown World
Why won't the following compile?
I'm tired and not an Oracle guy but need this simple stored proc working so I can run some tests from the BPM framework to troubleshoot some issues we are facing with calling Oracle stored procs.
TIA
Suity
Code:
CREATE OR REPLACE PROCEDURE sp_AddTestData
(sTEST_DATA IN NVARCHAR2, iTEST_ID OUT INTEGER) AS
BEGIN
iTEST_ID := seqTestData.nextval;
INSERT INTO TEST_DATA VALUES (iTEST_ID,sTEST_DATA);
END
PROCEDURE sp_AddTestData compiled
Warning: execution completed with warning
I'm tired and not an Oracle guy but need this simple stored proc working so I can run some tests from the BPM framework to troubleshoot some issues we are facing with calling Oracle stored procs.
TIA
Suity
Last edited:
18:47


