Home » SQL & PL/SQL » SQL & PL/SQL » invalid picture format when converting from sql7 to oracle9i
icon5.gif  invalid picture format when converting from sql7 to oracle9i [message #242610] Mon, 04 June 2007 06:04 Go to next message
Messages: 1
Registered: June 2007
Junior Member
I have recently converted a few of my branch office database from sql to oracle9i. The Image data was converted successfully to blob when converting from sql2000. The process was to migrate data using ms DTS to oracle by creating a new table and then exporting data in long raw format and later altering table to change to blob. But when i converted from sql7 in the above process i get an invalid picture message without any error code when accessing the data. help is required.

2) in one database I got out of memory message while just scrolling down. it did not even let me delete the data at the specified row Id. it was in sql7

[Updated on: Mon, 04 June 2007 07:02]

Report message to a moderator

Re: invalid picture format when converting from sql7 to oracle9i [message #242722 is a reply to message #242610] Mon, 04 June 2007 18:59 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
you need to do a binary comparison (start with size or checksum verification) of the data in both tables. Once you are sure that the data has been transferred correctly, make sure that your client application has a "compatible" codepage (characterset) with the database. Do a google on "blob image garbage character set"
Previous Topic: database
Next Topic: cursor exit problem
Goto Forum:

Current Time: Fri Oct 21 22:59:49 CDT 2016

Total time taken to generate the page: 0.10189 seconds