RE: anydata datatype update help

From: Inka Bezdziecka <IBezdziecka_at_cupe.ca>
Date: Fri, 04 Oct 2002 11:13:45 -0800
Message-ID: <F001.004E1237.20021004111345@fatcity.com>

Rachel,
do you know which system privilege of resource did the trick? inka

-----Original Message-----
Sent: Friday, October 04, 2002 1:24 PM
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: Inka Bezdziecka
  INET: IBezdziecka_at_cupe.ca

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 Fri Oct 04 2002 - 14:13:45 CDT