Passing parameters for Oracle Stored Procedures
Hi, I have created a package with a procedure name test_2 that has a OUT parameter type number. see code below... PACKAGE test_pkg IS FUNCTION conta_reg RETURN NUMBER; PRAGMA restrict_references(conta_reg,wnds,wnps,rnps); PROCEDURE test_2(tot OUT NUMBER); END; PACKAGE BODY TEST_PKG IS FUNCTION conta_reg RETURN NUMBER IS total NUMBER; BEGIN SELECT COUNT(*) INTO total FROM ASSUNTOS; RETURN total; END; PROCEDURE test_2(tot OUT NUMBER) IS total NUMBER; BEGIN SELECT COUNT(*) INTO total FROM ASSUNTOS; tot:= total; END; I have tried to call the test_2 procedure using this anonimous block: begin TEST_PKG.test_2(:outvar); end; and I received the following error: Error, dco2.DatabaseError: (1008, 'ORA-01008: not all variables bound') Does anybody knows what is wrong? Regards Ricardo
participants (1)
-
ricardo@cnbe.mar.org.uk