| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Oracle stored procedur call do not work from ESQL code |
« View previous topic :: View next topic » |
| Author |
Message
|
| shatvani |
 Posted: Mon Mar 08, 2010 1:31 pm Post subject: Oracle stored procedur call do not work from ESQL code |
 |
|
Newbie
Joined: 08 Mar 2010
Posts: 6
|
Hi,
I have an Oracle database and I would like to call its stored procedure what would give back a cursor, but I'm always getting this error message:
| Quote: |
| Text:CHARACTER:[DataDirect][ODBC Oracle driver][Oracle]ORA-06550: line 1, column 8: PLS-00306: wrong number or types of arguments in call to 'SELECTUSER' ORA-06550: line 1, column 8: PL/SQL: Statement ignored |
ORACLE code in DB:
| Code: |
CREATE OR REPLACE PACKAGE BROKER.broker_pkg
IS
TYPE user_ref_cursor IS REF CURSOR RETURN USERS%ROWTYPE;
END broker_pkg;
/
CREATE OR REPLACE PROCEDURE BROKER.SELECTUSER (
uname IN USERS.NAME%TYPE,
result_cur OUT SYS_REFCURSOR
)
AS
BEGIN
OPEN result_cur FOR
SELECT *
FROM users
WHERE users.NAME = uname;
END;
/ |
ESQL code in Compute node:
| Code: |
CREATE PROCEDURE Selection(IN user_name CHARACTER) LANGUAGE DATABASE DYNAMIC RESULT SETS 1 EXTERNAL NAME "BROKER.SELECTUSER";
CALL Selection('Hatvani István', Environment.ResultSet1[]); |
Please, help me!  |
|
| Back to top |
|
 |
| shatvani |
| Posted: Tue Mar 09, 2010 7:34 am Post subject: |
|
|
Newbie
Joined: 08 Mar 2010
Posts: 6
|
Hi,
I had got the answer at last.
I had to check the Procedure returns results checkbox at Advanced tab of the ODBC Driver Manage or the odbc.ini must be edited on Linux.  |
|
| Back to top |
|
|
| Muhammad Haider |
| Posted: Sun Aug 19, 2012 12:24 am Post subject: |
|
|
Apprentice
Joined: 14 Mar 2011
Posts: 43
|
| Thanks, it helped to solve the error. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
