Re: undocumented pl/sql syntax

Thank you Andrew,

but I can't find in the oracle documentation, the syntax of these two commands and of others; I'm consulting the "PL/SQL User Guide and Reference", the "Oracle 7 Server Application Developer's Guide" and the O7 SQL Reference.
The only example I found is "Type xx is Record..." or "Type xy is Table..." but in the package sys.standard ypu can read  type BOOLEAN is (FALSE, TRUE);
or
  subtype POSITIVE is BINARY_INTEGER range 1..2147483647; or
  type VARCHAR2 is NEW CHAR_BASE; (what is this keyword New?)

Do you know the manuals that explain me these commands?

I've also an othe question I can't give an answer, I need to compare in the package I said some variables with hex operations (like InData & 0x000000ff), can you give me any hints?

"Andrew Hardy" <nobody_at_spam.from.news.AdvanticaTech.com> wrote in message news:9jjm5g$eu4$1_at_sun-cc204.lut.ac.uk...
> Both TYPE and SUBTYPE are well-documented - TYPE is a PL/SQL user-defined
> type used for creating composite types e.g. Record or Table, whilst
 SUBTYPE
> is a PL/SQL type that is based on an existing type.
>
> Andy
>
> "Raffaele D'Alba" <raffaele.d'alba_at_snamprogetti.eni.it> wrote in message
> news:3b5c53bf$1_at_adm.eni.it...
> > I'm developing a package that implement some functions from a library
> > already developed in an other language, and I need to declare same
 specific
> > type of data.
> >
> > Searcing some example in the package SYS.STANDARD, I found same
 declarations
> > like type, subtype and so like... but I can't find any documentation of
 the
> > syntax of that construct.
> >
> > Anybody can help me? There is any undocumented syntax in PL/SQL.
> >
> > The database I currently use is 7.3.4
> >
> > thank you in advance, Raffaele
> >
> >
>
>
Received on Tue Jul 24 2001 - 10:20:42 CDT