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
pvr_msg
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

Regards,
Ramana
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
BlackSwan
Messages: 25046
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: 64139
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).

Regards
Michel
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: Thu Dec 08 08:21:33 CST 2016

Total time taken to generate the page: 0.09407 seconds