I agree wholeheartedly. Its like the "ol' days" when
you'd see apps ported from flat file or isam to a
relational model. They'd have tables with two columns
key varchar2(1000)
data longraw
So you would have no pesky restrictions like datatype,
precision, domains etc etc etc
Magic! ...not
Cheers
Connor
- "MacGregor, Ian A." <ian_at_SLAC.Stanford.EDU>
wrote: > I remember when anydata was first discussed a
few
> months ago. I questioned how it could be part of
> proper database design; from what domain would the
> anydata column draw its values? As I recall
> everyone advised against its use, "It is a bad idea
> in Access and so it is in Oracle." was the gist of
> the comments. One wag proposed having two fields in
> the database, a sequence based primary key and the
> anydata field. Apparently that person was too shy
> to rely on rowid's :)
>
> Why did you decide to use anydata? How does it
> benefit to your application? It strikes me as a bad
> idea, but I have not researched it at length.
>
> Ian MacGregor
> Stanford Linear Accelerator Center
> ian_at_SLAC.Stanford.edu
>
> -----Original Message-----
> Sent: Friday, October 04, 2002 10:24 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Stephane,
>
> if there is a new function, then it is hidden so
> deeply in the docs
> that even I can't find it. And I'm pretty good and
> coming up with
> "creative" search patterns.
>
> ANYDATA is an object, a way of storing different
> types of data in a
> single column. You store the data type metadata with
> the column.
>
> More information on this... when the other DBA ran
> the PL/SQL routine
> in a different account which had "resource" instead
> of just "connect"
> privileges, it ran....
>
> interesting!
>
> Rachel
>
> --- Stephane Faroult <sfaroult_at_oriolecorp.com>
> wrote:
> > Rachel,
> >
> > First time I hear about the ANYDATA type but I
> like to share my
> > ignorance and I guess it must be something akin to
> a C 'void *' - ie
> > a pointer to 'something'. To bind properly, Oracle
> needs two things :
> > a) a pointer to the start of the memory area
> > b) something to tell how big this memory area is.
> Either it's a 'well
> > known' type, or you must use an end marker
> (typically, a '0' with
> > character strings), or you must explicitly give a
> size.
> >
> > IMHO Oracle blows up because b) is missing. If you
> can insert, there
> > must be some way of telling it how large the
> variable is. I can't see
> > why it would be specific to an update (except if
> the PL/SQL engine is
> > buggy, which obviously it is, but even more so
> than appears to the
> > eye). Are you sure that there is not some obscure
> new function ... ?
> >
> > HTH
> >
> >
>
>
> __________________________________________________
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Rachel Carmichael
> INET: wisernet100_at_yahoo.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: MacGregor, Ian A.
> INET: ian_at_SLAC.Stanford.EDU
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com
> San Diego, California -- Mailing list and web
> hosting services
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"Remember amateurs built the ark - Professionals built the Titanic"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Sat Oct 05 2002 - 05:48:30 CDT