CREATE OR REPLACE FUNCTION RVELAZQUES.Get_Currency_Desc(pvCurrCd VARCHAR2) RETURN VARCHAR2 AS

   CURSOR c_val IS
      SELECT des1 AS ddesc
     FROM   sqltime.sy_curr_code
     WHERE  currency_code = pvCurrCd;
    --
    vret sqltime.sy_curr_code.des1%TYPE;
BEGIN
   BEGIN
     --
     OPEN c_val;
     FETCH c_val INTO vret;
     CLOSE c_val;
     --
   EXCEPTION
     WHEN OTHERS THEN
      vret := NULL;
   END;
  RETURN vret;
   --
END Get_Currency_Desc;
/

EXCEPTION
     WHEN OTHERS THEN
      vret := NULL;

  1  CREATE TABLE S_SALES_CENTER
  2  (
  3  SALES_CENTER_ID NUMBER(12) NOT NULL,
  4  CURRENCY_CODE VARCHAR2(3 BYTE),
  5  MASTER_SALES_CENTER_ID NUMBER(12),
  6  DISPATCH_PHONE_NUM VARCHAR2(20 BYTE),
  7  INF_SRC_DB VARCHAR2(3 BYTE) NOT NULL,
  8  COLLECT_RDP VARCHAR2(1 BYTE) DEFAULT 'Y',
  9* )
SQL> /
)
*
ERROR at line 9:
ORA-00904: : invalid identifier