dojjol
asked on
package session value not set
Hi,
I am trying to get the value from varaible from session but some how I get null value not really sure the reason.
Could use help.
create or replace
PACKAGE CONVPKG AS
TYPE MY_TYPE IS RECORD (
column1 NVARCHAR2(1),
coulmn2 VARCHAR2(1)
);
PROCEDURE loadP;
FUNCTION getP RETURN Varchar2;
END CONVPKG;
create or replace
PACKAGE BODY DELCCONVPKG AS
my_cached boolean := false;
my MY_TYPE := null;
PROCEDURE loadP
AS
OutParam MY_TYPE;
BEGIN
IF my_cached THEN
OutParam.column1 := 'b';
outparam.column1 := 'B';
my := outparam;
END IF;
END;
FUNCTION getP RETURN VARCHAR2
AS
BEGIN
DBMS_OUTPUT.PUT_LINE('c');
RETURN my.column1;
END;
BEGIN
loadP;
I am trying to get the value from varaible from session but some how I get null value not really sure the reason.
Could use help.
create or replace
PACKAGE CONVPKG AS
TYPE MY_TYPE IS RECORD (
column1 NVARCHAR2(1),
coulmn2 VARCHAR2(1)
);
PROCEDURE loadP;
FUNCTION getP RETURN Varchar2;
END CONVPKG;
create or replace
PACKAGE BODY DELCCONVPKG AS
my_cached boolean := false;
my MY_TYPE := null;
PROCEDURE loadP
AS
OutParam MY_TYPE;
BEGIN
IF my_cached THEN
OutParam.column1 := 'b';
outparam.column1 := 'B';
my := outparam;
END IF;
END;
FUNCTION getP RETURN VARCHAR2
AS
BEGIN
DBMS_OUTPUT.PUT_LINE('c');
RETURN my.column1;
END;
BEGIN
loadP;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.