Re: select and insert long column in a stored procedure

From: Karen <karen.abgarian_at_fmr.com>
Date: 2000/08/10
Message-ID: <3992B5F2.25E4C738@fmr.com>#1/1

You will have to use PLSQL. To accomplish the task, you can do something like:

for i in (select long_col from table) loop insert into table values(i.long_col);
end loop;

I dont think INSERT..SELECT can be implemented using DBMS_SQL at all. Someone please post if I am wrong.

And finally it is advisable to use LOBs instead of LONGs.

Regards
Karen Abgarian

luio wrote:

> in fact, I could not find a way to solve this, can you just tell
> me how to do
>
> insert tb2(x,...) select x... from tb2 where ....
>
> x is long data type
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
Received on Thu Aug 10 2000 - 00:00:00 CDT