Create a view using OUT values from a procedure - how?

From: Mike <none_at_nospam.com>
Date: Thu, 7 Oct 2004 15:38:15 -0400
Message-ID: <1hagmxylyog8o.1uvhs5xhgwq64.dlg@40tude.net>

Hi, I¡¦m creating a view and would like to have two of the columns to contain data obtained from a procedure which has two out values. I'm using Oracle 9.2

For example

Create view student.v_grades
(str_student, studentID, str_higrade, str_lowgrade) AS
Select studentdb.student,

          Studentdb.studentID,
/* How do I get student grades from the procedure */ FROM studentdb
WHERE ( ¡K) e.g. procedure:

Create Procedure PR_getgrades(

P_higrade OUT VARCHAR2,
P_lowgrade OUT VARCHAR2
P_studentID IN Number)

IS
BEGIN /*process data*/

P_higrade := result1;
P_lowgrade :=result2;

End;
END PR_getgrades;
/

Thanks,

Mike Received on Thu Oct 07 2004 - 14:38:15 CDT