Results 1 to 5 of 5

Thread: [RESOLVED] pl/sql stored procedure

Threaded View

  1. #1

    Thread Starter
    PowerPoster JuggaloBrotha's Avatar
    Join Date
    Sep 2005
    Location
    Lansing, MI; USA
    Posts
    4,286

    Resolved [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;
    /
    Last edited by JuggaloBrotha; Mar 31st, 2016 at 07:13 PM.
    Currently using VS 2015 Enterprise on Win10 Enterprise x64.

    CodeBank: All ThreadsColors ComboBoxFading & Gradient FormMoveItemListBox/MoveItemListViewMultilineListBoxMenuButtonToolStripCheckBoxStart with Windows

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width