Friday, March 23, 2012

Paramaterised Query to ORACLE database - not all variables bound

Hi

when I run this query against an Oracle 9 datasource I get a message saying 'not all variables bound'

select <some fields> from star
where nr_jahr_star = :Year

my datasource is correct as the same report runs fine if I just put in a fixed year and I have the Oracle client software on both my PC and the RS server

I've tried various combinations with the parameter settings also with no luck.

Thanks

Steven

Year is a reserved word - did you try changing the parameter name?

No comments:

Post a Comment