PLS 00306 Error

[organickarma]

Enviroment

CR 9
Jsp front end jdk 1.4.2
Oracle 10g (JAva stored procedure)

Her is what is happening, when i execute my stored proc within toad it completes successfully

Moment I use it as a data source for my CR it throws the PLS 00306 error for wrong number or types of parameters.

Now all the reports run without problem in our dev and qa enviroments

The DB scripts are exactly the same in UA but some of the reports seem to be failing.

Can anyone shed any light on this issue

all the stored procs are a minor variation of this template

create or replace schema.proc(param 1 varchar2, param2 varchar2,param 3 varchar2, date1 date, date2 date)

within this is a java stored proc.

Is this some conflict between oracle and CR or the ref cursor and CR..

Pls help

 

[groggle]

What data source are you using to connect to Oracle?

ODBC or native?

 

[organickarma]

ODBC!

 

[organickarma]

I might have possibly found the problem...but can some of the experts here help me put it in perspective.

This whole bunch of reports rests within a java app and when I tested the same through stand alone CR it was throwing the error for some reports and ran ok with other reports. Finally I checked the odbc configuration on my local machine and the stored procedure returns results was not checked ... I did that and problem disappeared. What I do not understand is how this affects only a few reports and not all. And when these reports are published to the server...the server ODBC settings are same for all reports...So why do only some of them throw the error.

Note: All reports use stored procs with ref cursors.

I am bemused by this