Hello I have this problem
Say I create package like this:
CREATE OR REPLACE PACKATE TEST_PACKAGE
PROCEDURE TEST(RetCode OUT VARCHAR2);
END TEST_PACKAGE;
CREATE OR REPLACE PACKATE BODY TEST_PACKAGE
gvc_String VARCHAR2(20) := 'abc'
PROCEDURE TEST(RetCode OUT VARCHAR2) IS
BEGIN
RetCode := gvc_String;
END;
END TEST_PACKAGE;
Now I create an anonymou block like this
DECLARE
RetCode VARCHAR2(20);
BEGIN
TEST_PACKAGE.TEST(RetCode);
DBMS_OUTPUT.PUT_LINE(RetCode);
END;
The problem is that nothing is printed. RetCode is null. It looks like the global variable is not initialized at the moment I am calling the test procedure... But why? It should be initialized as soon as I touch the package, right?
EDITED...
Edited by: xxsawer on 29.3.2012 8:12
Edited by: xxsawer on 29.3.2012 9:13