Why i am getting this error
ERROR at line 5: PL/SQL: SQL Statement ignored
Here is my code

CREATE OR REPLACE PROCEDURE SELECT_VEHICLE_VEHICLE_TYPE
(vehicletype IN VARCHAR2, vname OUT VARCHAR2, vtype OUT VARCHAR2, efirstname OUT VARCHAR2)
AS
BEGIN
SELECT v.V_NAME INTO vname,v.V_TYPE INTO vtype,e.E_FIRST_NAME INTO efirstname
FROM VEHICLE_TABLE v
INNER JOIN
EMPLOYEE_TABLE e
ON v.V_ID=e.E_VEHICLE_FK;
END;

Does the keyword INTO belong in front of the alias?
I've only ever seen it without the wor INTO (just a space).

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.