RS01819: STORED PROCEDURE CALL IN CONNECTOR DOESN'T WORK IN ORACLE

Operational Decision Manager V8.5.1.2 Fix Pack
Operational Decision Manager V8.6.0.2 Fix Pack
Operational Decision Manager V8.7.0.1 Fix Pack
Operational Decision Manager V8.7.1 Download Document
Operational Decision Manager V8.7.1 Refresh Pack
Operational Decision Manager z/OS 8.7.1.2 Fix Pack

APAR status

• Closed as program error.

Error description

• When trying to call a stored procedure from an event connector,
  although the procedure is defined with a single out parameter
  of type SYS_REFCURSOR to returns the resultset,
  the following error is received in System.out:
  [11/25/14 12:03:06:937 CET] 0000007a JDBCWorker E
  BEES9107E: An exception occurred when processing the JDBC
  System event DummyJdbcEvent.
  Exception is java.sql.SQLException: ORA-06550: line 1, column 7:
  
  PLS-00306: wrong number or types of arguments in call to
  'STOREDPROC'
  ORA-06550: line 1, column 7:
  PL/SQL: Statement ignored
  

Local fix

Problem summary

• ****************************************************************
  USERS AFFECTED:
  Operational Decision Manager V8.0.1 Events JDBC connector
  (Oricle DB) users
  
  ****************************************************************
  PROBLEM DESCRIPTION:
  Store procedure call in JDBC connector does not work in Oricle.
  

Problem conclusion

• Problem fixed.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• 999
  

Fix information

• Fixed component name

  WS DECISION CTR

• Fixed component ID

  5725B6900

Applicable component levels

• R801 PSY

     UP