Link to home
Start Free TrialLog in
Avatar of obrienj
obrienj

asked on

Calling Function from within SQL Expression

I have an oracle function that I use that takes in three values and returns one string.  I can call this function from within any sql query/view etc.
Is it possible to call an oracle function from within an SQL Expression in Crystal Reports?
Avatar of Ashish Patel
Ashish Patel
Flag of India image

Yes it should, if other sql functions can be called.
Avatar of obrienj
obrienj

ASKER

well, I don't konw if they can or not, I seem to be having trouble doing so.  I have never called a function from an SQL Expression before.  Do you know the syntax for doing such a thing?
ASKER CERTIFIED SOLUTION
Avatar of Ashish Patel
Ashish Patel
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of obrienj

ASKER

okay, thanks.