Re: What is the problem with this stored procedure?
Date: Thu, 11 May 2006 07:33:59 -0400
Message-ID: <sKGdnT7dUsqxvP7ZnZ2dnUVZ_u2dnZ2d_at_comcast.com>
"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
:
: Also tell me the diff b/t the AS DECLARE and IS...
:
: looking forward for the response.....
:
either AS or IS are OK.... the problem is DECLARE -- it is only used for anonymous blocks, and is implied for stored procedures (actually replaced by the procedure specification)
make sure you spend some time reading the PL/SQL user's guide, Application Developer's Guides, and other items recently mentioned in a "Where to start" post.
++ mcs Received on Thu May 11 2006 - 13:33:59 CEST