Author Topic: OCS 6.1 with Oracle 8.1.7  (Read 3946 times)

Craig

  • Guest
OCS 6.1 with Oracle 8.1.7
« on: January 01, 1970, 12:00:00 AM »
Anybody using OCS 6.1 with Oracle 8.1.7?

We have a problem where we get an exception in dbclient_oracle :

Application exception occurred:
App: ../bin/6.1.000.09/winnt/dbclient_oracle.exe (pid=460)
When: 2/26/2002 @ 14:39:10.312
Exception number: c0000005 (access violation)

The problem occurs when tring to execute the stored procedure for the particular campaign list e.g. sp101101.

The error occurs in an Oracle library function called vsnupr which converts a string to an integer. Presumably this is converting the OUT params from the SP (VARCHAR2).

Have tried the latest Oracle patchset (8.1.7.3) without success.

Previosuly worked fine with OCS 6 and Oracle 8.1.6
Also works fine with OCS 6.1 and MS SQL server 7

Any ideas ?