Home » SQL & PL/SQL » SQL & PL/SQL » Can't copy a row because it contains long raw column
Can't copy a row because it contains long raw column [message #38793] Wed, 15 May 2002 08:57 Go to next message
Mike Oakes
Messages: 25
Registered: December 2000
Junior Member
Hello,
I'm trying to create an additional row in a table by copying another row except i get an error that says something about invalid long option. This is occuring because I have a long raw column in the table. Is there a way to create a new row by coping long raw columns. Is there some package I can use?

Example. Table a has 2 columns ID NUMBER, and FILE LONG RAW.
When trying to copy row 1 to row2 I get the error.
I also cannot do create table A from table b, if table b has a long raw column
Any help would be greatly appreciated.
Mike O.
Re: Can't copy a row because it contains long raw column [message #38795 is a reply to message #38793] Wed, 15 May 2002 09:25 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Mike, see:

http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:1484804943800
Previous Topic: Getting rid of decimals in the date
Next Topic: STORED PROCEDURES
Goto Forum:
  


Current Time: Fri Apr 26 05:18:58 CDT 2024