Re: Help: Package Cursor Problem: Invalid Column?

In article <8kdbdj$76o$1_at_nnrp1.deja.com>,   t_johann_at_my-deja.com wrote:

I found my problem. It was in the FOR UPDATE OF MYR_T. I simply removed the 'OF MYR_T' and the invalid column error went away. I guess I could have specified the column I am updating as well, but I haven't gotten to that.

> 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.
>

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