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

Mike wrote:

> 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

It can not be done.

Hasn't your instructor taught you anything about how Oracle works?

There are solutions ... but as this is clearly classwork you need to figure them out for yourself. So what you get is a hint.

Hint: Use functions.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)