MQSeries.net :: View topic - IIB ODBC SQLERRORTEXT Encoding

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » IIB ODBC SQLERRORTEXT Encoding

IIB ODBC SQLERRORTEXT Encoding

« View previous topic :: View next topic »

Author

Message

ivan261

Posted: Wed Dec 02, 2015 7:38 am Post subject: IIB ODBC SQLERRORTEXT Encoding

Newbie

Joined: 07 Aug 2015
Posts: 2

Hello.

Such simple code

Code:

CREATE PROCEDURE TEST_EX(IN m CHARACTER)
LANGUAGE DATABASE
EXTERNAL NAME "TEST_EX";

CREATE COMPUTE MODULE TestFlow_Compute
CREATE FUNCTION Main() RETURNS BOOLEAN
BEGIN
   CALL CopyMessageHeaders();
   CREATE LASTCHILD OF OutputRoot DOMAIN 'XMLNSC' NAME 'XMLNSC';
   BEGIN
      DECLARE EXIT HANDLER FOR SQLSTATE LIKE '%'
      BEGIN
         set OutputRoot.XMLNSC.Root.SQLCODE = SQLCODE;
         set OutputRoot.XMLNSC.Root.SQLSTATE = SQLSTATE;
         set OutputRoot.XMLNSC.Root.SQLNATIVEERROR = SQLNATIVEERROR;
         set OutputRoot.XMLNSC.Root.SQLERRORTEXT = SQLERRORTEXT;
      END;
      CALL TEST_EX('xxx');
   END;
   set OutputRoot.XMLNSC.Root.OK = 'x';

   RETURN TRUE;
END;

CREATE PROCEDURE CopyMessageHeaders() BEGIN
   DECLARE I INTEGER 1;
   DECLARE J INTEGER;
   SET J = CARDINALITY(InputRoot.*[]);
   WHILE I < J DO
      SET OutputRoot.*[I] = InputRoot.*[I];
      SET I = I + 1;
   END WHILE;
END;

CREATE PROCEDURE CopyEntireMessage() BEGIN
   SET OutputRoot = InputRoot;
END;
END MODULE;

On Windows 8.1
LCID Name DisplayName
---- ---- -----------
1033 en-US English (United States)

IIB 9.0.0.3

gives result

Code:

(0x01000000:Folder):XMLNSC = ( ['xmlnsc' : 0x94fa8750]
(0x01000000:Folder):Root = (
(0x03000000:PCDataField):SQLCODE = -1 (INTEGER)
(0x03000000:PCDataField):SQLSTATE = 'DHY000' (CHARACTER)
(0x03000000:PCDataField):SQLNATIVEERROR = 20001 (INTEGER)
(0x03000000:PCDataField):SQLERRORTEXT = '[IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-20001: ??????, ??? xxx ORA-06512: ?? "APPDB.TEST_EX", line 4 ORA-06512: ?? line 1' (CHARACTER)
(0x03000000:PCDataField):OK = 'x' (CHARACTER)
)
)

And on linux
LANG=en_US.UTF-8
IIB 9.0.0.3

Quote:

[ODBC]
InstallDir=/opt/ibm/mqsi/9.0.0.3/ODBC/V7.0
UseCursorLib=0
#IANAAppCodePage=4
IANAAppCodePage=8
UNICODE=UTF-8

result is

Quote:

(0x01000000:Folder):XMLNSC = ( ['xmlnsc' : 0x7f84d01a1680]
(0x01000000:Folder):Root = (
(0x03000000:PCDataField):SQLCODE = -1 (INTEGER)
(0x03000000:PCDataField):SQLSTATE = 'DHY000' (CHARACTER)
(0x03000000:PCDataField):SQLNATIVEERROR = 20001 (INTEGER)
(0x03000000:PCDataField):SQLERRORTEXT = '[unixODBC][IBM][ODBC Oracle Wire Protocol driver][Oracle]ORA-20001: ^_@825B, <8@ xxx ORA-06512: at "IVAN.TEST_EX", line 4 ORA-06512: at line 1' (CHARACTER)
(0x03000000:PCDataField):OK = 'x' (CHARACTER)
)
)

Stored procedure:

Code:

create or replace procedure TEST_EX(m varchar2)
IS
BEGIN
raise_application_error(-20001, 'Привет, мир '||m);
END;

If I send non ASCII characters throw output parameters IIB takes it ok.

How could I get the correct non ASCII text throw fault? Is it possible?

maurito

Posted: Thu Dec 03, 2015 1:26 am Post subject:

Partisan

Joined: 17 Apr 2014
Posts: 358

is your Oracle database set up to support Unicode and DBCS ?

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » IIB ODBC SQLERRORTEXT Encoding

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP