call PL/SQL functions outside SQL Expressions?

[GretaD]

Hi

Do anyone know if it is possible to call PL/SQL functions outside SQL Expressions? I have a PL/SQL function where I want to send in the parameterfield I get in the report as a parameter to the function. That does not seem to be possible in SQL expressions...

I use Crystal Reports XI and Oracle 9 database.

Thanks!
Greta

 

[Madawc]

In Crystal 10, I've found that SQL won't allow a parameter in DATEADD, but you can get the same result by compairing the results of DATEDIFF to a parameter value. That was in a Stored Procudure, but an SQL Expression should be the same.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10