Re: Using packaged constants in queries

don't know why oracle does behave like this - but i use code like this:

create or replace PACKAGE BODY DIV IS FUNCTION GetPkgVariable (

   pszVar varchar2 ) return varchar2 is szRet varchar2 (32767); begin

     execute immediate 'begin ' || ':1 := ' || pszVar || '; end;' using
     out szRet; return (szRet); end;

FUNCTION SetPkgVariable (
  ppszVar varchar2,
 pppszValue varchar2 ) return varchar2 is begin execute immediate

     'begin ' ||
ppppszVar || ' := :2; end;' using pszValue; return (GetPkgVariable

     (pszVar)); end;

end;

select div.getpgkvariable('pkg.var') from dual;

--
Posted via dBforums
http://dbforums.com