0

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;

2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by thines01
0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.