Link to home
Start Free TrialLog in
Avatar of dojjol
dojjolFlag for Afghanistan

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;
ASKER CERTIFIED SOLUTION
Avatar of flow01
flow01
Flag of Netherlands image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial