Jump to content


Photo
- - - - -

368 - SQL ERROR: INVALID DATA TYPE FOR SQL


4 replies to this topic

#1 Mike Schoen

Mike Schoen

    Expert

  • Members
  • PipPipPipPip
  • 198 posts
  • Gender:Male
  • Location:Guelph, Canada

Posted 18 November 2002 - 09:42 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!

#2 Shaun Rudland

Shaun Rudland

    Expert

  • Members
  • PipPipPipPip
  • 165 posts
  • Location:Queensland, Australia

Posted 18 November 2002 - 11:45 PM

G'Day Mike,

I remember a few years ago I had a similar problem with a function that would run correctly for a few iterations, and then produce some form of PRO-IV generated SQL error. If restarted, it would process the 'failed' transaction correctly. I finally worked out that it was due to numeric host variables within the SQL statements being corrupted by the execution of the statement. This may or may not have been calling procedures; my memory is hazy. The host variables were used within the statements, and within the PRO-IV code. The solution was to create another set of host variables, that were loaded before the SQL statement, and were only used within the SQL statement.

Just a thought.

Regards

Shaun
PRO-IV free for 385 Days B)

#3 Mike Schoen

Mike Schoen

    Expert

  • Members
  • PipPipPipPip
  • 198 posts
  • Gender:Male
  • Location:Guelph, Canada

Posted 20 November 2002 - 02:07 PM

Thanks Shaun - while checking to see if I was using numerics I found the actual problem - I was using full function sql to select only the key field of the table, but telling pro-iv that it should expect the full file, ie all columns.

For some reason, solaris would let us get away with this, but the aix build would not...

#4 AlexKRE

AlexKRE

    Newbie

  • Members
  • Pip
  • 1 posts

Posted 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.

#5 Richard Bassett

Richard Bassett

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 696 posts
  • Location:Rural France

Posted 23 October 2011 - 05:17 PM

LOL @ idiotic spambot
Nothing's as simple as you think



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users