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

Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL: Constants in TYPE declarations?

Re: PL/SQL: Constants in TYPE declarations?

From: Andy Hardy <junkmail_at_[127.0.0.1>
Date: Sun, 9 Nov 2003 02:41:53 +0000
Message-ID: <LpvYUWExlar$Ewez@[127.0.0.1]> 





In message <bojtjf$99d$05$1_at_news.t-online.com> , FlameDance 
<flamedance_at_gmx.de> writes



>How can I do what I want? Am I missing something? Any workarounds? Or is

>it simply not supported by PL/SQL?




Correct, it is not supported.



The closest approach might be to use the %TYPE (e.g. blah 
my_table.my_column%TYPE) to base your package variables on table column 
definitions.


-- 
Andy Hardy. PGP ID: 0xA62A4849


Received on Sat Nov 08 2003 - 20:41:53 CST












Original text of this message













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