Oracle Variables

[Bonediggler1]

Hello-

I need to create a report in Crystal with an Oracle back-end and a query that uses unbound variables Beg_Date) and End_Date). When trying to do this I get the "ORA-01008: not all variables bound" error.

Unfortunately I do not have ANY development rights in Oracle - I can only query off the reporting instance.

How to approach this problem?


Thank you!!

 

[hilfy]

Where is this query? Are you putting it in a Command? If so, you cannot use Oracle syntax for the parameters. Instead you have to use Crystal Syntax ({?Beg_Date} and {?End_Date}) and create the parameters in the command, not in the report itself.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[Bonediggler1]

Thanks Dell. This works great~