How to link between oracle procedure parameter and Crystal Reports parameter.

[Former Member]

Hi

Am using a Oracle DB Procedure with parameter inside the Crystal Report.

Used the DB Procedure in Sub Report. The link from Main Report to the Sub Report is using the parameter which is used in the DB Procedure.
While running the report from the Crystal Developer its working good where as when we are executing this Report from the Server (For Front End) the DB Procedure is not handiling the Parameter that is passed from the Front End and getting below isue.
Error: The Viewer could not process an event. Cannot create temp temp file [CRSDK00000615] ---- Error code:0 [CRWEB00000119]

Please Advice on this

Thanks

Satya

[former_member11696]

Try searching for Crystal Reports Parameters, there is a DOC out there on how to create them and what CR expects.

Don

[former_member11696]

When using SP's in a report the SDK is expecting the Parameter values to be set before setting the logon info, so it can pass the values the SP expects.

check the API order you are setting the log on info in your app.

Don

[Former Member]

Thank you. Am assuming this answer will be useful for me.

We are providing one IN parameter and one OUT Ref cursor.

The IN parameter and one of the OUT parameter from the ref cursor are same.

In the report the parameter is taking from the Ref Cursor.

Please advice on handling of the Parameters and also API order settings.

Satya

[former_member11696]

When you say "Server" is is BOE or CR Server or an application you wrote using one of the CR SDK's?

[Former Member]

We Deployed report in BOE Server and calling from Java application.

[Former Member]

We have already given the Synonyms and Grants on related DB Objects.

[Former Member]

Probably a rights issue. Make sure the User which runs reports from Report Server on Oracle has correct rights.

Ian

[Former Member]

We have already given the Synonyms and Grants on related DB Objects.