Help: Package Cursor Problem: Invalid Column?

From: <t_johann_at_my-deja.com>
Date: 2000/07/10
Message-ID: <8kdbdj$76o$1@nnrp1.deja.com>#1/1

I have a cursor defined in my package body that is giving me trouble. I'm running Oracle 7.3.4 on an HP box.

I have a procedure in a Package with a cursor that has a join. The code compiles fine, and I can run the SQL in SQLPLUS, but when I run it I get:

ORA-00904: invalid column name, at the following locations (see => below).

I've tried having the cursor outside the procedure and declaring my own TYPE with no luck. Any help would be greatly appreciated! The procedure is below.

-Tom

PROCEDURE sp_logic_test IS

    CURSOR logic_test_cur IS
=> SELECT t.acct, t.prf, p.r_scr, p.intro_prf

        FROM myr_t t
           , p_stat p
       WHERE t.r_scr= p.r_scr
         FOR UPDATE OF myr_t;

   BEGIN
=> FOR rtd_cur IN logic_test_cur

      LOOP
        UPDATE myr_t
           SET prf = rtd_cur.intro_prf;
      END LOOP;
      COMMIT;

   END sp_logic_test;

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jul 10 2000 - 00:00:00 CDT