| Not All Variables Bound [message #5848] |
Fri, 07 March 2003 11:49 |
Michele
Messages: 77
Registered: December 2000 |
Member |
|
|
Hello,
I have written a small stored procedure:
(SW_CASEREF IN VARCHAR2)
IS
PERSID NUMBER;
BEGIN
SELECT PERS_ID INTO PERSID FROM WRKX.SW_CASEREF C WHERE C.CASE_REF = SW_CASEREF;
DELETE FROM TEST.TEST@DB_LK.WORLD W WHERE W.PERS_ID = PERSID;
COMMIT;
INSERT INTO TEST.TEST@DB_LK.WORLD
SELECT * FROM PRODX.CNTRCTR_EXT P WHERE P.PERS_ID = PERSID;
COMMIT;
END;
When I run the lines of code individually through SQL*Plus, it works fine. But when I run the
EXECUTE UPDATE_BUBBA_TEMS('21-2');
I get the not all variables bound error: ORA-01008. It seems to point to the commit line between the delete and insert.
When I run the stored procedure without the insert code, it also runs fine.
Any ideas on what I am doing wrong.
Thank You
Michele
|
|
|
] 
Members
Search
Help
Register
Login
Home
