CR-XI report doesn't detect Param changes to Oracle SP

[MJRBIM]

Crystal XI
Native Connection to Oracle 9i

We have a CR-XI report created against an ORACLE Stored Procedure with four (4) Parameters that are passed throught to the CR-XI report.

We have added one (1) more Parameter to the ORACLE Stored Procedure - but the new parameter doesn't show up in the existing CR-XI reports.

We tried a bunch of tests -
1.) Disconnecting the CR-XI report from the database, then reconnecting.
2.) "verify database" on the CR-XI report.
3.) Creating a new "Blank" report against the Stored Procedure.

The new "Blank" report shows the correct five Parameters from the ORACLE Stored Procedure - but there doesn't seem to be any way to get the existing reports to detect the Parameter change to the ORACLE Stored Procedure.

We really don't want to have to recreate our reports if we add parameters to an ORACLE Stored Procedure.

Anyone seen this before - and if so, do you have a fix...?

Thanks in Advance.

 

[synapsevampire]

Never heard of such a thing, except when people thought they were pointing to the new SP, but were not.

Database->Verify Database is intended to do what you're after.

Another approach would be to use Database->Set Database Location and point to the SP, it doesn't require a rewrite of the report and will force CR to read the SP again.

Again, I suspect some permissioning or wrong database instance/synonymn or some such at work here, I've changed SPs hundreds of times.

-k