Problem in calling stored procedure stored in UTF-2 codeset DB

From: Mina Jung <minajung_at_pacific.net.sg>
Date: Thu, 21 May 1998 17:41:11 +0800
Message-ID: <3563F6B7.D4C25954@pacific.net.sg>

Hi,

We have a stored procedure just returning status of data to client app. Our front-end application development tool is Centura 1.1.1 and Oracle server version is 7.3.2 on OPEN VMS.

We've got 2 DBs. One of them is using JA16SJIS as its code set while the other's codeset is defined as AL24UTFFSS which is UTF-2. Recent test found that when this stored procedure is called by using SqlPLSqlCommand from centura, Oracle DB with AL24UTFFSS returns this error message to client PC:

PLS 00801- Internal error [ 76120 ]

Does anyone know what the weird message means? Same call to JA16SJIS DB works just fine. Our PC OS is NT4 with Service pack3 and connection made to Oracle server is through TCPIP by using SQLNet 2.3. Also, our NLS_Lang in PC registry is American_America.JA16SJIS.

Any advise/suggestion appreciated.

Mina Received on Thu May 21 1998 - 04:41:11 CDT