Re: pl/sql

In article <3A6816C0.E4518408_at_bill.mts.ru>,   Valery Yourinsky <vsu_at_bill.mts.ru> wrote:

> CREATE OR REPLACE PROCEDURE vsu_word_search
> AS
> line CHAR(100) := 'that is fine yes it is';
> pat CHAR(10) := '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
> --
> htp.p('has_match = TRUE'); htp.br;
> htp.p('bacref.COUNT='||bacref.COUNT); htp.br;
> htp.p('bacref.FIRST='||bacref.FIRST); htp.br;
> htp.p('bacref.LAST='||bacref.LAST); htp.br;
> ---
> IF bacref.COUNT > 0 THEN
> FOR K IN bacref.FIRST .. bacref.LAST LOOP
> htp.p('K='||K||' "' ||bacref(K)||'"');
> htp.br;
> END LOOP;
> END IF;
> END IF;
> END;
> /

I am sorry but it did not work. Is there something that I dont understand? Program returns that has_match is TRUE, but that bacref.COUNT = 0
so the array is still empty

Rami Huhtala

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 31 2001 - 04:57:50 CST