Home » SQL & PL/SQL » SQL & PL/SQL » Error(4,9): PLS-00103: Encountered the "," symbol (Oracle Developer 11g)
icon5.gif  Error(4,9): PLS-00103: Encountered the "," symbol [message #572659] Fri, 14 December 2012 22:39 Go to next message
johnnyinthe248
Messages: 3
Registered: December 2012
Location: Detroit
Junior Member
I have no idea what I'm doing wrong... or maybe it's just I have no idea what I'm doing... but I am trying.
This is the code I am trying to execute:


CREATE OR REPLACE function Format_Emp_Name
(p_fname employee.emp_fname%TYPE,
p_initial employee.initial%TYPE,
p_lname .employee.emp_lname%TYPE)
RETURN varchar2
IS
v_emp_name varchar2(30);
--
BEGIN

SELECT
employee.emp_fname || ' ' || employee.initial || ' ' ||employee.emp_lname Employee_Name
INTO v_emp_name
FROM hartmar.employee;

RETURN v_emp_name;

EXCEPTION
when no_data_found then
dbms_output.put_line('Invalid name');
when others then
dbms_output.put_line('Invalid name');
dbms_output.put_line('SQLERROR');
--
END;
/
Re: Error(4,9): PLS-00103: Encountered the "," symbol [message #572660 is a reply to message #572659] Fri, 14 December 2012 22:42 Go to previous messageGo to next message
johnnyinthe248
Messages: 3
Registered: December 2012
Location: Detroit
Junior Member
This is the full text of the error message:
Error(4,9): PLS-00103: Encountered the symbol "." when expecting one of the following: in out <an identifier> <a double-quoted delimited-identifier> ... long double ref char time timestamp interval date binary national character nchar The symbol "<an identifier>" was substituted for "." to continue.
Re: Error(4,9): PLS-00103: Encountered the "," symbol [message #572661 is a reply to message #572660] Fri, 14 December 2012 22:54 Go to previous messageGo to next message
BlackSwan
Messages: 23159
Registered: January 2009
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>p_lname .employee.emp_lname%TYPE)
the leftmost period character to the right of "p_lname ." appears to be errant.

Re: Error(4,9): PLS-00103: Encountered the "," symbol [message #572662 is a reply to message #572661] Fri, 14 December 2012 22:56 Go to previous message
johnnyinthe248
Messages: 3
Registered: December 2012
Location: Detroit
Junior Member
Thank you for the help. I will definitely read the documentation.
Previous Topic: insert query issue
Next Topic: Character String Buffer too small
Goto Forum:
  


Current Time: Sun Dec 21 22:30:28 CST 2014

Total time taken to generate the page: 0.08987 seconds