RE: Problems with PL/SQL - URGENT

From: Michael Netrusov <mnetrusov_at_concretemedia.com>
Date: Tue, 18 Jul 2000 17:49:11 -0400
Message-Id: <10562.112334@fatcity.com>

Hi Jorge,=20

would you please post the script to create that test table you are = using? =20
I've ran your procedure with another select statement ( select dummy = from
dual ) - it works;

Michael =20

-----Original Message-----
From: Jorge Luiz Alves [mailto:jalves_at_mdic.gov.br] Sent: Tuesday, July 18, 2000 17:48
To: Multiple recipients of list ORACLE-L Subject: Problems with PL/SQL - URGENT

Hi all,

I have a pl/sql block that declare a cursor for read a view = ALL_TAB_COLUMNS.
The select statement that form cursor, runs at sqlplus and doesn=B4t = works in
the storage procedure, that is my problem. I=B4m running the procedure = with
owner.

Please give a look in my procedure:

procedure pr_charge_data as

     cursor find_tabs_c is
            select table_name, column_name
              from all_tab_columns
             where owner =3D 'TEST' and
                   table_name  like 'AGREG%' and
                   column_name like 'ID%'   and
                   column_name not in ('ID_TITLE','ID_ECONOMIC_BLOCK')
           order by column_id;=20
     wtable varchar2(30);
     wcol   varchar2(30);
begin
     open find_tabs_c;
     loop
        fetch find_tabs_c into wtable,wcol;
        if find_tabs_c%NOTFOUND then
           dbms_output.put_line('*** end ***');
           exit;
        end if;
        dbms_output.put_line(wtable);
     end loop;
     close find_tabs_c;

end;

THE RESULT IS: *** end ***, when i execute SP.

and when i run de sql statement it brings all the record that attempt = the
conditions in where clause;

Thank you in advance,

Jorge Alves.

--=20
Author: Jorge Luiz Alves
  INET: jalves_at_mdic.gov.br

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may Received on Tue Jul 18 2000 - 16:49:11 CDT