The set serveroutput on. 
The create or replace function get_new_no (id_no varchar2) 
Return varchar2 as 
Declare 
Id_no2 varchar2 (100); 
The begin 
Id_no2:=id_no | | 'Tom'; 
Return id_no2; 
end; 

CodePudding user response:

 
The create or replace 
The function get_new_no (id_no varchar2) 
Return varchar2 as 

Id_no2 varchar2 (100); 
The begin 
Id_no2:=id_no | | 'Tom'; 
Return id_no2; 
end; 

Remove the declare

CodePudding user response:

Post code is no problem to perform, specific error have a look at the post

CodePudding user response:

Tried to compile successfully

 
The create or replace function get_new_no (id_no varchar2) 
Return varchar2 
As 
Id_no2 varchar2 (100); 
The begin 
Id_no2:=id_no | | 'Tom'; 
Return id_no2; 
end;