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
Function Y on RMT remote database
I know Function Y on the RMT database works. But if I run Function X, it gives me
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;
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;
Code:
ORA-06503: PL/SQL: Function returned without value ORA-06512: at XAV, line 6 ORA-06512: at line 7
Comment