Home » Other » General » reports are not generated
reports are not generated [message #259007] Tue, 14 August 2007 02:13 Go to next message
pvr_msg
Messages: 7
Registered: August 2006
Location: hyderabad
Junior Member
Hi to all members

This is ramana

My problem with long datatype is

we have one table with long column.In that table dialy heavy rows are inserted so we take backup of that table every day into another backup table.But long column datatype rows are not inserted.

ora-0997-illegal use of long datatype

so we create another table with same structure instead of long datatype we use clob datatype.

now rows are inserted to backup table fine.

but here using that backup table we generate reports.
that reports are not working.(crystal reports)

so what to do

base table with same reports working fine

Re: reports are not generated [message #259012 is a reply to message #259007] Tue, 14 August 2007 02:28 Go to previous messageGo to next message
Michel Cadot
Messages: 68643
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Error?

Regards
Michel
Re: reports are not generated [message #259019 is a reply to message #259007] Tue, 14 August 2007 02:59 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Use an 'insert' statement to backup all the rows without the 'long' column and then use an 'update' statement to populate the 'long' column.

David
Previous Topic: Web Development And Data Should Reflect In Oracle Database
Next Topic: Enterprise Wide Deployment
Goto Forum:
  


Current Time: Tue Apr 23 07:57:02 CDT 2024