>
> 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
variables.
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