Question

I getting the error when creating query for PL/SQL

CREATE OR REPLACE FUNCTION Customer_Details 

RETURN VARCHAR2;

IS 

Cust_Name VARCHAR2 (20); 

BEGIN 

SELECT FirstName 

INTO Cust_Name

FROM Customer

WHERE CustomerID = '300001';

RETURN Cust_Name;

END;

/ 

I'm getting the error:

3/1 PLS-00103: Encountered the symbol "IS"

Errors: check compiler log

Answer 1

I have corrected the code, there was just one error at line 3,

you had used RETURN VARCHAR2; , the semicolon here ends the return statement.

but actually we do it like, first we declare the return type of out function and then the actual variable, which in case is Cust_name.

So RETURN VARCHAR2 IS Cust_Name VARCHAR2 (20); is just`a single statement.

CREATE OR REPLACE FUNCTION Customer_Details
RETURN VARCHAR2 IS Cust_Name VARCHAR2 (20);
BEGIN
SELECT FirstName
INTO Cust_Name
FROM Customer
WHERE CustomerID = '300001';
RETURN Cust_Name;
END;
/

This code works fine.