on sql/sp

Long type operation in store procedure.
how to select the long and insert it into a table. Tom only solves insert a long type into a table in a store procedure

how to implement next statemente in store procedure? right now, it reported error message, that I use long type in a query in a store procedure.

create tb1(....., long xx)

insert into tb1(...., xx) select .... xx from tb1

it is said we can use dbms_execute to implement this. but how?

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Mon Aug 07 2000 - 00:00:00 CDT