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 -> Anchor to type of a constant ?

Anchor to type of a constant ?

From: R Chin <rchin_at_panix.com>
Date: Fri, 12 Apr 2002 22:52:52 -0400
Message-ID: <a986gm$9hi$1@reader1.panix.com> 





Anchoring  to type of a constant....this is not allowed, right ?



In pkg spec I declare:


const_note     CONSTANT VARCHAR2(8) := 'DO-RE-ME';



In separate anony. block..


my_note  my_pkg.const_note%type;



I get PLS-00206....



Is there anyway around this ?



Thanks



robert
Received on Fri Apr 12 2002 - 21:52:52 CDT












Original text of this message













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