[RESOLVED] pl/sql stored procedure

[JuggaloBrotha]

My crash course in Oracle's PL/SQL and I was able to create a stored procedure already that runs fine, but this one it's complaining about the Join line in the query, can anyone spot the issue:

CREATE OR REPLACE PROCEDURE DISP_MARINA_SLIP_OWNER (I_SLIP_ID IN MARINA_SLIP.SLIP_ID%TYPE) AS
I_MARINA_NUM MARINA_SLIP.MARINA_NUM%TYPE;
I_SLIP_ID MARINA_SLIP.SLIP_ID%TYPE;
I_BOAT_NAME MARINA_SLIP.BOAT_NAME%TYPE;
I_OWNER_NUM MARINA_SLIP.OWNER_NUM%TYPE;
I_FIRST_NAME OWNER.FIRST_NAME%TYPE;
I_LAST_NAME OWNER.LAST_NAME%TYPE;

BEGIN
INTO I_FIRST_NAME, I_LAST_NAME, I_MARINA_NUM, I_SLIP_NUM, I_BOAT_NAME, I_OWNER_NUM
SELECT o.FIRST_NAME, o.LAST_NAME, m.MARINA_NUM, m.SLIP_NUM, m.BOAT_NAME, m.OWNER_NUM
FROM OWNER o
  INNER JOIN MARINA_SLIP m
    ON o.OWNER_NUM = m.OWNER_NUM
WHERE m.SLIP_ID = I_SLIP_ID;

DBMS_OUTPUT.PUT_LINE(I_MARINA_NUM);
DBMS_OUTPUT.PUT_LINE(I_SLIP_ID);
DBMS_OUTPUT.PUT_LINE(I_BOAT_NAME);
DBMS_OUTPUT.PUT_LINE(I_OWNER_NUM);
DBMS_OUTPUT.PUT_LINE(I_FIRST_NAME);
DBMS_OUTPUT.PUT_LINE(I_LAST_NAME);
END;
/

[szlamany]

INNER JOIN MARINA_SLIP

needs to be

INNER JOIN MARINA_SLIP m

since you alias with m. later on - right?

[JuggaloBrotha]

I'd neglected that when I copied it in, my original script had that alias and isn't the problem.

[techgnome]

What is it complaining about exactly?

-tg

[JuggaloBrotha]

Issue ended up being I was using a variable with the same name as a column, I changed that variable to a different name and it works fine.