Skip to Content
0

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

Jan 25 at 01:31 PM

119

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Ian Waterman Jan 25 at 02:08 PM
0

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

Ian

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0
Don Williams
Jan 25 at 06:18 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0
avatar image
Former Member Jan 25 at 02:56 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Don Williams
Jan 29 at 02:44 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
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

0
Don Williams
Feb 14 at 10:49 PM
0

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

Don

Share
10 |10000 characters needed characters left characters exceeded