RE: Need Help Please - With Procedures

From: Deepak Thapliyal <deepakthapliyal_at_yahoo.com>
Date: Wed, 28 Nov 2001 16:11:40 -0800
Message-ID: <F001.003CFB0A.20011128141529@fatcity.com>

raja,

I would recommend that you heed Kevin's advise .. in the meantime .. here is a quick start e.g. for what you are looking to do ..

create procedure Blah (

        para_owner in varchar2, 
        para_table in varchar2) is
  cursor c1(v_owner varchar2, v_table varchar2) is
     select blah1 , blah1 , ...
          from bigBlah
          where blah= v_owner
           and bloh = v_table;

begin

    for rec in c1(para_owner, para_table )     loop

         dbms_output.put_line(rec.blah1);
         dbms_output.put_line(rec.blah2);
         .... 

    end loop;
end;
/

hth
Deepak
--- Viraj Luthra <viraj999_at_lycos.com> wrote:
> Yeah I am reading, but if I could get a framework
> for a procedure, referring to my sql's, then that
> would be a big help.
>
> Please help.
>
> rgds,
>
> raja
> --
>
> On Wed, 28 Nov 2001 11:25:01
> Kevin Lange wrote:
> >Two books ..... Oracle PL/SQL Programming .... and
> Oracle Built-in
> >Packages. Both from Steven Feuerstein on O'reilly
> press. Good books for
> >this.
> >
> >-----Original Message-----
> >Sent: Wednesday, November 28, 2001 1:05 PM
> >To: Multiple recipients of list ORACLE-L
> >
> >
> >Hello all,
> >
> >I have attached an sql file containing a set of
> sql's (6) of them, which
> >gives me information regarding table fragmentation.
> What I need to do is
> >instead of writing seperate sql's, I need to write
> a procedure, where in I
> >pass the owner and table name and then the result
> comes out, as you will see
> >in the last sql.
> >
> >What I need is, if some one could please help in
> writing a procedure? How to
> >put cursors and use all the information in
> different cursor variables etc.
> >
> >Please help.
> >
> >Thanks.
> >
> >Rgds,
> >
> >Raja
> >
> >
> >
> >--
> >Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> >--
> >Author: Kevin Lange
> > INET: kgel_at_ppoone.com
> >
> >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
> >also send the HELP command for other information
> (like subscribing).
> >
>
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Viraj Luthra
> INET: viraj999_at_lycos.com
>
> 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
> also send the HELP command for other information
> (like subscribing).

---

Do You Yahoo!?
Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deepak Thapliyal
  INET: deepakthapliyal_at_yahoo.com

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
also send the HELP command for other information (like subscribing).

Received on Wed Nov 28 2001 - 18:11:40 CST