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
--- [EMAIL PROTECTED] 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 <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 10/04/2002 06:33 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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).
__________________________________________________
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
