The function to_char is not available as an external, database, or built-in func

[EArumugam]

Hi All,
I am getting the below error when i use the to_char function in report studio.

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-126'.
UDA-SQL-0219 The function to_char is not available as an external, database, or built-in function

My requirement is, i am having a table which contains the user id, user name, and date format, time format.

for each user id there have specific date format(stirng values like 'dd-MON-yyyy', dd-mon-yyyy') defined in that table.

I am trying to use the dateformat column in to_char as below.

to_char([date column from fact table],[date format for the user logged in])

when i try to run i am getting the error.

but fyi below expression working fine.
to_char({sysdate}, [date format for the user logged in]) -WORKING FINE.


Thanks ,
eas