PL/SQL (MOSC)

MOSC Banner

Function is not working

edited Sep 12, 2013 8:17AM in PL/SQL (MOSC) 2 commentsAnswered ✓
Hi experts.This fucntion is not working. 
ssn is soscial security number.

CREATE OR REPLACE FUNCTION test.tel_to_apply (ssn varchar2(9))
   RETURN varchar2
IS
   myssn   varchar2(9);

BEGIN
   myssn := ssn

   IF myssn in (select * from test.aplicar)
   THEN
      myssn := to_char(to_number(ssn)+1);
   end if;
   RETURN myssn;
END;                                                             
/

RETURN myssn;
Error at line 13
ORA-00900: invalid SQL statement
   

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center