MQSeries.net :: View topic

marcin.kasinski · Posted: Mon Aug 02, 2010 12:47 am Post subject: ODBC error

MB 6.0.0.5 UNIX
Database Oracle

Hello I have problem with execution Oracle procedure from broker.

Everything works fine if I place schema, package na procedure in external procedure definition (... EXTERNAL NAME "CBZG.ZG_ADMIN.wersja"; ).

When I use schema name from Compute datasource name (... EXTERNAL NAME "ZG_ADMIN.wersja"; ) I get error:

(0x03000000):Text = 'The procedure is unknown to the database and no definition could be found.'
(0x01000000):Insert = (
(0x03000000):Type = 5
(0x03000000):Text = 'CBZG.ZG_ADMIN.WERSJA'

Database definition:

FUNCTION wersja RETURN VARCHAR2 IS
BEGIN
RETURN 'Specification: ' || mc_SpecVersion || '. Body: ' || mc_BodyVersion;
END wersja;

External definition:

CREATE PROCEDURE PodajWersje() RETURNS CHARACTER
LANGUAGE DATABASE
EXTERNAL NAME "ZG_ADMIN.wersja";

ODBC definition:

[CBZG]
Driver=/opt/IBM/mqsi/6.0/DD64/lib/UKora20.so
Description=DataDirect 6.0 Oracle Wire Protocol
HostName=X.X.X.X
;HostName=XXX
PortNumber=1521
SID=XXX
;ServiceName=XXX
CatalogOptions=0
EnableStaticCursorsForLongData=0
ApplicationUsingThreads=1
EnableDescribeParam=1
OptimizePrepare=1
WorkArounds=536870912
ProcedureRetResults=1
ColumnSizeAsCharacter=1

ODBC error from trace (I hope this part of log refers to my broker error):

2010-08-02 10:30:55.123276 ppid=4410:pid=4414:1 EXIT SQLGetTypeInfo with return code -1 (SQL_ERROR)

2010-08-02 10:30:55.123276 ppid=4410:pid=4414:1 HSTMT 0x001abe00

2010-08-02 10:30:55.123276 ppid=4410:pid=4414:1 SWORD -99 <unknown>

Can you help me fix it ?
I don't know why it doesn't work.
_________________
Marcin