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: 25578
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: 65153
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: Sum through a hierarchy
Next Topic: Oracle Time Difference
Goto Forum:

Current Time: Tue Aug 22 08:15:06 CDT 2017

Total time taken to generate the page: 0.01435 seconds