PL/SQL (MOSC)

MOSC Banner

Got PLS-00306 error but don't know why

edited May 24, 2018 2:05AM in PL/SQL (MOSC) 5 commentsAnswered ✓

Hello there,

I have a simple script and I got PLS-00306 error.  I have no clue why.  Here is the script:

Begin

For xx in (select vendor_id, vendor_name from ap.ap_suppliers)

loop

    DBMS_OUTPUT.PUT_LINE (

         xx.vendor_id,

         xx.vendor_name);

END LOOP;

END;

If I use only one column, anyone, I don't have this error.  Please help.

Thanks,

Ning

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center