| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: anydata datatype update help
and in a different environment, it worked for us as well.
We've narrowed it down to being due to "some" environment variable. We thought it might be the privs (the account that worked was created with resource, the one that died had connect only) but that's not it.
I'm just glad I don't have to do the digging. All *I* have to do today is generate the scripts to create the new tablespaces, users, tables, indexes, constraints, grants, views, synonyms, stored procedures, fill out the documentation for the hosting company (for the first time ever, so this isn't a braindead operation, I have to figure out what they want and what they need), determine if what they are monitoring for in the database is what I want them to monitor, write the data load procedures and test them ....
in other words, a typical afternoon's work and I should be able to get it done with one hand tied behind my back (makes typing interesting as I am a touch typist)
:)
At least it's Friday
Rachel
--- Jared.Still_at_radisys.com wrote:
> Rachel,
>
> The following worked for me:
>
> create or replace type person as object (
> last_name varchar2(20)
> ,first_name varchar2(20)
> );
> /
>
> create table rc (
> id number
> , person_data sys.anydata
> )
> /
>
> insert into rc ( id, person_data )
> values (1, sys.anydata.ConvertObject(Person('Still','Jared')))
> /
>
> commit;
> update rc set person_data =
> sys.anydata.ConvertObject(Person('Still','Carla'))
> where id = 1
> /
>
> commit;
>
> There are examples in the Application Developers Guide.
>
> Jared
>
>
>
>
>
>
> Rachel Carmichael <wisernet100_at_yahoo.com>
> Sent by: root_at_fatcity.com
> 10/04/2002 06:33 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
> Subject: anydata datatype update help
>
>
> the subject line pretty much describes it.
>
> 9.2.0.1, Solaris 2.8
>
> We are using the ANYDATA datatype and while we have no problems with
> insert or select or delete, the process blows up (ora-7445, coredump)
> when we try to update the ANYDATA column. Within a PL/SQL process,
> using aliased tablenames and bind variables for all values:
>
> UPDATE MI.T_IN03_ObjPrpty
> SET IN03_Value_AD = :b7
> ,IN03_Seq_NO = :b6
> ,RF01_Publisher_KY = :b5
> ,IN03_Amend_DT = :b4
> ,RF02_Status_KY = :b3
> ,IN03_Status_DT = :b2
> WHERE IN03_ObjPrpty_KY = :b1
>
> IN03_Value_AD is the ANYDATA column. Statement works fine if we
> remove
> that column. Statement blows up if we remove all OTHER columns or if
> we
> run it as is.
>
> We've posted an iTAR and are waiting. I've searched MetaLink and the
> docs. Nothing useful.
>
> But the search of the docs left me with a suspicion that you can't
> update an ANYDATA column.
>
> Has anyone either successfully updated an ANYDATA column or found
> documentation somewhere that says you can't?
>
> this is stopping development on a critical system. I'm not the
> primary
> DBA on it, but the consultant DBA doesn't have access to MetaLink and
> isn't on this list so I'm helping out.
>
> Suggestions? Worst case I suppose we could delete the original row
> and
> insert the new one but that's kludgy and messy and an additional
> performance hit on a system that needs to "fly like the wind". I'd
> rather fix this properly... of course Oracle is capable of saying
> that
> the delete and insert IS the workaround and/or standard procedure for
> this.
>
> Rachel
>
> __________________________________________________
> 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:
> INET: Jared.Still_at_radisys.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: 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).Received on Fri Oct 04 2002 - 13:23:47 CDT
 |
 |