Re: Inserting binary data to an column

>
> http://www.psoug.org/reference/convert_func.html#chtr
> http://www.psoug.org/reference/dbms_xdbutil_int.html#xinh
> http://www.psoug.org/reference/convert_func.html#crth
> http://www.psoug.org/reference/utl_raw.html#urctr
> http://www.psoug.org/reference/builtin_functions.html
> http://www.psoug.org/reference/dbms_reputil.html#rurv
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Group
> www.psoug.org

Thnx o lot, this will help a little bit. But im not able to bring this in an correct way^^. Lets make an example:
1.in a table (table_a) exists a column (col_a) of type anydata 2.the data in anydata is an object (lets make a simple object (obj_a) with 2 itmes 1st_name (of varchar2) and 2nd (phonenumber (of number)) 3. in the destination db is obj_a already defined

if i understand it right, i can get the raw presentation of col_a (with the obj_a) with utl_raw.cast_to_raw.

Now i want to create an INSERT statement that should the following: 1. insert the raw data in col_b from table_b (will have the same definition as table_a and col_a, but will be in another db) 2. the data in col_b should not be the raw data. it must represent the original obj_a as in table_a.

So there must be a "recast"? or anything that the destination db recognize the raw data as the obj_a.

My problem is, that i will realize this independent from the types in the anydata field.
Surely, i can step through the anydata field and findout the type and type the cast and recast (eg utl_raw.cast_to_varchar2 and utl_raw.cast_to_raw.

But i will find a way to transmitt an binary representation of the data, that will later (in the destination db) recognize as the original data.

How can i do this?

Thnx for ur help

Micha Received on Wed Nov 07 2007 - 04:14:28 CST