Jump to content


AlexKRE

Member Since 04 Oct 2011
Offline Last Active Oct 10 2011 04:34 PM
-----

Posts I've Made

In Topic: 368 - SQL ERROR: INVALID DATA TYPE FOR SQL

04 October 2011 - 03:59 PM

We keep getting the error '368 - SQL ERROR: INVALID DATA TYPE FOR SQL' on an AIX installation running 4.6r216 and oracle 8.1.6.

This happens in an update which passes a transaction file and calls a global update to do record updates. We have some custom sql and pl/sql routines called in the global.

After the third iteration in the parent update, we get this
error and a rollback. Quitting out, and re-running the update then proceeds to correctly process the record that caused the rollback the first time.

The oracle trace log does not show any sql errors, this error gets generated by pro-iv.

Any ideas would be appreciated!

For given trouble there is mdf recovery. It is able to work out trouble with corrupted or lost sql data. The software works under any Windows OS. It uses contemporary methods of restoring files from any SQL Server versions.