CODEWITHSUNDEEP
oracle-databaseplsql
ho-ho
ho-ho

Reputation: 1

Error PLS-00103 in PL/SQL function

This code won't compile. I don't know what's going on. I'm using Oracle 8i

CREATE OR REPLACE FUNCTION SALMINS 
IS RETURN NUMBER
   SAL NUMBER(10);
BEGIN
 SELECT MIN(SALARIO) INTO SAL FROM EMPLE;
 RETURN (SAL);
END;

Error:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2/1      PLS-00103: Encountered the symbol "IS" when expecting one of the
         following:
         ( return compress compiled wrapped

Table definition:

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 EMP_NO                                    NOT NULL NUMBER(4)
 APELLIDO                                           VARCHAR2(10)
 OFICIO                                             VARCHAR2(10)
 DIR                                                NUMBER(4)
 FECHA_ALT                                          DATE
 SALARIO                                            NUMBER(10)
 COMISION                                           NUMBER(10)
 DEPT_NO                                            NUMBER(2)

Upvotes: 0

Views: 191

Answers (1)

Aleksej
Aleksej

Reputation: 22969

CREATE OR REPLACE FUNCTION SALMINS 
RETURN NUMBER IS   -- and not IS RETURN NUMBER
   SAL NUMBER(10);
BEGIN
 SELECT MIN(SALARIO) INTO SAL FROM EMPLE;
 RETURN (SAL);
END;

Upvotes: 2

Related Questions