Re: cursor using select from subquery

Shouldn't you be using the syntax SELECT x,y,z INTO v_x,v_y,v_z ...

v_colums are variables you've declared.

>> However, if I want to use this query with a cursor within a
>> stored procedure:
>>
>> cursor c_usprobj is
>> select aup.usid, aup.program, obj.object_name
>> from (select usid, program
>> from users, programs ) aup,
>> program_objects obj
>> where obj.program = aup.program;
>>
Received on Tue Feb 04 1997 - 00:00:00 CST