Re: What is the problem with this stored procedure?
Date: Thu, 11 May 2006 10:43:29 +0200
Message-ID: <e3utfi$278$1_at_sunce.iskon.hr>
"Wallace" <princevictor.moses_at_gmail.com> wrote in message
news:1147336269.084363.56450_at_j73g2000cwa.googlegroups.com...
> Thanx for ur reponse....
>
> Thats working fine....
>
> Now it is telling error in "
> DBMS_OUTPUT.PUT_LINE(collections(i).COSA_FORMAL_ID); "
>
> Error :
> 1. Error(8,3): PL/SQL: Statement ignored
> 2. Error(8,39): PLS-00302: component 'COSA_FORMAL_ID' must be declared
You declared collections as employee rowtype. That means you can refer only to columns that exist in table. 2nd error tells you that no such column exist in table.
> Also tell me the diff b/t the AS DECLARE and IS...
>
Syntax for creating procedure demands such structure with no alternative :-) Received on Thu May 11 2006 - 10:43:29 CEST