None except defining noteType varchar2(8) and declaring const_note
as constant noteType and then using noteType as type of your vars.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"R Chin" <rchin_at_panix.com> wrote in message news:a986gm$9hi$1_at_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 Mon Apr 15 2002 - 06:36:00 CDT
