cursor using select from subquery

From: Gerard H. Pille <ghp_at_infosoft.be>
Date: 1997/01/30
Message-ID: <32F0F4E5.1D6F@infosoft.be>#1/1

I have a select that works fine:
select aup.usid, aup.program, obj.object_name  from (select usid, program

        from users, programs ) aup,
      program_objects obj

 where obj.program = aup.program;

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;

the stored procedure gives compilation errors on the first "(".

Does anybody know what's wrong? Is it not allowed to use selects from subqueries in PL/SQL?

Kind reGards,

     \ /   |
      x    s
     / \
     Gerard

Received on Thu Jan 30 1997 - 00:00:00 CST