0

Hello,

I have been trying to write a procedure that should select the user ID and display their names. Below is the code that I have written, however, when I try to compile it, there are errors. Please someone help me as to where I'm going wrong with this code.
any help or guidance will be much appreciated. Thanks

SET R REPLACE PROCEDURE getDetails
      (p_id IN PERSON_ATTRIBUTES.USER_ID%TYPE,
      p_first_name out PERSON_ATTRIBUTES.FIRST_NAME%TYPE,
      p_last_name out PERSON_ATTRIBUTES.LAST_NAME%TYPE)  
is
begin
SELECT USER_ID, FIRST_NAME, LAST_NAME
INTO p_id, p_first_name, p_last_name
FROM PERSON_ATTRIBUTES
where USER_ID = p_id;
END; 
/

DECLARE
      p_first_name PERSON_ATTRIBUTES.FIRST_NAME%TYPE;
      p_last_name PERSON_ATTRIBUTES.LAST_NAME%TYPE;
BEGIN 
getDetails(308514267,p_first_name.FIRST_NAME,p_last_name.LAST_NAME);
DBMS_OUTPUT.PUT_LINE(p_first_name.FIRST_NAME, p_last_name.LAST_NAME);
END;
/
2
Contributors
1
Reply
12
Views
2 Years
Discussion Span
Last Post by pritaeas
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.