[RESOLVED] pl/sql stored procedure
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:
Code:
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;
/
Re: pl/sql stored procedure
INNER JOIN MARINA_SLIP
needs to be
INNER JOIN MARINA_SLIP m
since you alias with m. later on - right?
Re: pl/sql stored procedure
I'd neglected that when I copied it in, my original script had that alias and isn't the problem.
Re: pl/sql stored procedure
What is it complaining about exactly?
-tg
Re: pl/sql stored procedure
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.