Home » SQL & PL/SQL » SQL & PL/SQL » ora-997 error
ora-997 error [message #256564] Mon, 06 August 2007 00:43 Go to next message
Messages: 7
Registered: August 2006
Location: hyderabad
Junior Member
Hi to all,

when i am creating a table using with another table ther error is coming that ora-0997 illegal use of LONG data type.

In my parent table onle long column is there

how to create my child table using parent table(with long column)

plz send solution as soon as possible

Re: ora-997 error [message #256566 is a reply to message #256564] Mon, 06 August 2007 00:45 Go to previous messageGo to next message
Messages: 25474
Registered: January 2009
Location: SoCal
Senior Member
No Operating System name or version.
No Oracle version to 4 decimal places.
No code formatting (see http://www.orafaq.com/forum/t/59964/74940/)
No help. [You're On Your Own (YOYO)!]

LONG has been obsoleted. You should upgrade to 21st century.
Re: ora-997 error [message #256575 is a reply to message #256564] Mon, 06 August 2007 01:15 Go to previous message
Michel Cadot
Messages: 64953
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use PL/SQL is LONG is less than 32K.
Otherwise create your program (C, Java or what else).

Previous Topic: How to create a duplicate table in oracle without using select,create,insert etc. commands
Next Topic: class oracle/CDC/PublishApi does not exist
Goto Forum:

Current Time: Fri Jun 23 12:32:16 CDT 2017

Total time taken to generate the page: 0.11223 seconds