Re: Using packaged constants in queries

Thank you very much for your help.

It seems that when PL/SQL looks at Oracle package it sees it as executable code plus a source of type definitions, session variables, etc. But when SQL looks at Oracle package it sees it only as executable code. Thus the only thing we can do with packages from SQL is to call packaged functions and procedures.

Thanks again.

-- 
Posted via Mailgate.ORG Server - http://www.Mailgate.ORG