Need Function help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • noob2012
    New Member
    • Mar 2012
    • 1

    Need Function help

    Need help on function

    I am trying to understand how function X calling a remote database function Y and this is my code. It's not working. What am I doing wrong?

    Function X
    Code:
    CREATE OR REPLACE FUNCTION XAV(v_input IN Varchar2)
    RETURN return varchar2 AS
    x varchar2(100);
    BEGIN
    x:= VAX@RMT(v_input);
    END;
    Function Y on RMT remote database
    Code:
    CREATE OR REPLACE FUNCTION VAX(vAB IN Varchar2)
    RETURN varchar2 AS
    BEGIN
    if vAB = 'A' then return 'Andrew';
    elsif vAB = 'B' then return 'Bob';
    else return 'Cat';
    end if;
    END;
    I know Function Y on the RMT database works. But if I run Function X, it gives me
    Code:
    ORA-06503: PL/SQL: Function returned without value
    ORA-06512: at XAV, line 6
    ORA-06512: at line 7
  • debasisdas
    Recognized Expert Expert
    • Dec 2006
    • 8119

    #2
    this should work for you.

    Code:
    CREATE OR REPLACE FUNCTION XAV(v_input IN Varchar2)
    RETURN return varchar2 AS
    x varchar2(100);
    BEGIN
    x:= VAX@RMT(v_input);
    RETURN X;
    END;

    Comment

    Working...