| Author |
Message |
 Topic: How the REF CURSOR parameter can be passed to a Oracle SP? |
lliu
Replies: 0
Views: 1386
|
 Forum: WebSphere Message Broker (ACE) Support Posted: Mon Nov 24, 2003 9:06 am Subject: How the REF CURSOR parameter can be passed to a Oracle SP? |
PROCEDURE open_emp_cv (emp_cv IN OUT types.EmpCurTyp) AS
BEGIN
OPEN emp_cv FOR SELECT * FROM emp;
END open_emp_cv;
The types is defined in a package:
PACKAGE types AS
TYPE EmpCurTyp ... |
| Topic: Remote Oracle on Solaris from Compute Node problem |
lliu
Replies: 11
Views: 10514
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Nov 20, 2003 3:27 am Subject: Remote Oracle on Solaris from Compute Node problem |
Folks,
We have got the connection working now but it does not behave as we expected.
Our broker processes run under the ID "wmqi".
wmqi 2570 1 0 12:17:59 ? 0:00 bipservice BWMQ ... |
| Topic: Remote Oracle on Solaris from Compute Node problem |
lliu
Replies: 11
Views: 10514
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Nov 17, 2003 9:02 am Subject: Remote Oracle on Solaris from Compute Node problem |
OK, we've made some progress. We tested the flow using a known Sybase ODBC access and it worked OK. Now having bounced the broker (for the 1,000th time  ), we are reaching the Oracle DB. Howe ... |
| Topic: Remote Oracle on Solaris from Compute Node problem |
lliu
Replies: 11
Views: 10514
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Nov 17, 2003 7:42 am Subject: Remote Oracle on Solaris from Compute Node problem |
Thanks. There is a line on the top part of odbc.ini to declare the use of Merant Oracle driver.
I can access the remote Oracle database with broker ID/password from the broker server outside of t ... |
| Topic: Remote Oracle on Solaris from Compute Node problem |
lliu
Replies: 11
Views: 10514
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Nov 17, 2003 7:27 am Subject: Re: Remote Oracle on Solaris from Compute Node problem |
I have the same problem: the wmqi broker (with db2 database) on solaris cannot access remote Oracle database from Compute Node. I did the following set up:
1. modified odbc.ini file:
[SOPHIS_INTERFA ... |
| Topic: MQSI 2.0.2 |
lliu
Replies: 1
Views: 2450
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jan 25, 2002 6:47 am Subject: MQSI 2.0.2 |
After we migrated to mqsi 2.0.2 recently, the parameter MQMD.OriginalLength cannot be used any more, since it's always -1. Please see my trace file.
0x1000000)Properties = (
... |
