Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SELECT FROM TABLE(CAST... failure

Re: SELECT FROM TABLE(CAST... failure

From: meathammer <googler_at_google.com>
Date: Fri, 07 Jul 2006 17:30:03 -0400
Message-Id: <pan.2006.07.07.21.30.01.813000@google.com> 





On Fri, 07 Jul 2006 21:54:02 +0200, Sybrand Bakker wrote:


> You can't reference package variables (or constants) even if they are

> in the package specification. You'll need a very simply function to

> RETURN them.




thanks


I just learned today one can not reference pkg-level constant/variable in
SQL outside of PL/SQL --- never knew that
Received on Fri Jul 07 2006 - 16:30:03 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US