Re: pl/sql

ramirez134_at_my-deja.com wrote:
>
> In article <3A66DAF3.3E2375A_at_bill.mts.ru>,
> Valery Yourinsky <vsu_at_bill.mts.ru> wrote:
> > ramirez134_at_my-deja.com wrote:
> > >
> > > Where I can find pl/sql examples especially good OWA-packages
> > > examples.I am not found them nowhere.
> > >
> >
> > Oracle9i Application Server Using the PL/SQL Gateway
> > 5. Using the PL/SQL Web Toolkit
> > http://otn.oracle.com/docs/products/ias/doc_index.htm
> >
> > See also
> > http://otn.oracle.com/docs/products/ias/doc_index.htm
> >
> > Valery Yourinsky
> > --
> > Oracle8 Certified DBA
> >
>
> Could someone explain me how can I do that:
> I want serch word from line and copy it to the array
> and print it.
> I know that it goes something like that
>

  CREATE OR REPLACE procedure word_search   AS
  line char(20) := 'that is fine yes it is';   pat char(20) := 'is';
  bacref owa_text.vc_arr;

--
has_match BOOLEAN;
--
  BEGIN
   htp.htmlOpen;
   htp.headOpen;
   htp.title('word search');
   htp.headClose;
   htp.bodyopen;
--
-- No apostrophes!
   has_match := owa_pattern.match(line, pat, bacref);
   IF has_match = TRUE THEN
      FOR K IN bacref.FIRST .. bacref.LAST LOOP
         htp.p('K='||K||' "' ||bacref(K)||'"');
         htp.br;
      END LOOP;
   END IF;
--
   htp.bodyClose;
   htp.htmlClose;
  END;

Valery Yourinsky
-- 
Oracle8 Certified DBA