SQL & PL/SQL

Hi,
I need to create a procedure to return a recordset based on a single variable.

Basically they enter a student ID and I return their information so the in variable would be student_ID. Would it be as simple as this?

CREATE PROCEDURE GetGrades(@student_id in varchar2)

AS

Select stu_first_name, stu_last_name, stu_grade
from sfrstcr, spriden
where sfrstcr_pidm = spriden_pidm
and spriden_pidm = @student_id

RETURN

Any help would be appreciated.

New at procedures

Message was edited by:
robert2504