Error Accessing an Oracle Function

Discussion in 'Programming' started by mr_roomi, Mar 16, 2009.

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

    CREATE OR REPLACE FUNCTION simple RETURN VARCHAR2 IS
    a varchar2(10) := '';
    BEGIN
    select 'Simple' into a from dual;
    Return a;
    END simple;

    <cfstoredproc procedure="simple" datasource="MySource" returnCode ="yes">
    <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,
     
    mr_roomi, Mar 16, 2009 IP