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