> Ari,
> 	Hey, I never heard what you thought about that
> stored procedure I sent you.  Well, I have another
> question for you.  I have a table that consists of two
> fields a varchar2 and a long.  I want to replicate
> this table but I have tryed two methods but I don't seem
> to be able to "insert into..." with a "select from..."
> when a long data type exists.  Do you have any ideas?
> This has to be a process that can be run from a stored
> procedure so my knowledge is limited.
> Any help would be much appreciated, as always.
> Thanks,
> John
> -- 
> **********************************************************
> *  John Holland        (mailto:holland@blairlake.com)    *
> *  Technical Director                                    *
> *  BlairLake New Media     (http://www.blairlake.com)    *
> *  104 West 42nd Street              Tel 816.756.2121    *
> *  Kansas City, MO 64111-2301        Fax 816.756.2992    *
> **********************************************************

As for replicating long, you cannot do it straight out in Oracle7. Oracle8 gives
you LOB packages to handle it.

What you have to do is make a stored procedure (like you plan to), and define
two variables whose datatypes are VARCHAR2 and LONG.
Then, you can open a cursor on the table and FETCH the values into the two
Insert a new record into the second table, supplying the two variables.

Loop through the cursor until finished.

-Ari Kaplan
Independent Oracle DBA Consultant

<-> For 115+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->

Back to Ari Kaplan's Home Page ndex.htm">Back to Ari Kaplan's Home Page