OraFAQ Forum: SQL & PL/SQL » ORA-00997: illegal use of LONG datatype

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00997: illegal use of LONG datatype (Oracle 10g)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

ORA-00997: illegal use of LONG datatype [message #569202]

Mon, 22 October 2012 12:58

Chessaficionado
Messages: 4
Registered: October 2012
Location: Atlanta

Junior Member

Please help ..

When trying to create a temo table on a Database with :
create table
tkl_186523_temp as select * from tkl where tkl_cd = 'ACSCL' AND
ENTRY_DT >= '14-SEP-2012' AND INS_BY = 'CRTVRAM';

I'm getting an ERROR at line 2:
ORA-00997: illegal use of LONG datatype

Report message to a moderator

Re: ORA-00997: illegal use of LONG datatype [message #569204 is a reply to message #569202]

Mon, 22 October 2012 13:03

joy_division
Messages: 4266
Registered: February 2005
Location: East Coast USA

Senior Member

1. You cannot do a CTAS from a table that has a LONG datatype just as the error message says
2. ENTRY_DT >= '14-SEP-2012' is poor coding as you are "probably" comparing a DATE column to a character string.

Report message to a moderator

Re: ORA-00997: illegal use of LONG datatype [message #569735 is a reply to message #569204]

Wed, 31 October 2012 14:06

Chessaficionado
Messages: 4
Registered: October 2012
Location: Atlanta

Junior Member

Thanks for the response and my apologies in the delayed response.

Report message to a moderator

Previous Topic:	A better way to check every table for data?
Next Topic:	Sample Extraction

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 22 07:17:44 CDT 2013

Total time taken to generate the page: 0.30327 seconds