Error Accessing an Oracle Function

[khurampk]

Hi There,
I am trying to access an oracle function and getting an error.

CREATE OR REPLACE FUNCTION simple RETURN VARCHAR2 IS
BEGIN
RETURN 'Simple Function';
END simple;

<cfstoredproc procedure="simple" datasource="MySource" returnCode ="no">
<CFPROCRESULT name="simple_function">
</cfstoredproc>

Error:
Error Executing Database Query. [Macromedia][SequeLink JDBC Driver][ODBC Socket][Oracle][ODBC]Syntax error or access violation.

I do have access to this function. I tried it from SQL Plus and it works fine.

any help in this will be highly appreciated.

Regards,