Re: Context and Cursors

From: <bonanos_at_yahoo.com>
Date: Tue, 20 Jul 1999 06:22:09 GMT
Message-ID: <7n14ib$j6g$1@nnrp1.deja.com>

Hi Calista

Try writing two procudures. The first procedure will contain the loop that select the keywords, and the second will contain the context search, this is an easy way of making your code more readable, and easier to debug.

Without an error message it is difficult to say what would be causing the error.Also if you say what you are trying to do it would help.

First procedure

CURSOR itkeywords_cur IS
SELECT keyword from dbcodes where rtrim(SUBCLASS)='Automatic Data Processing and Telecommunication Services' or rtrim(SUBCLASS)='General-Purpose Automated Data Processing Equipment (Including Firmware), Software, Supplies, and Support Equipment';

BEGIN

htp.p('<html>');
htp.p('<head>');
htp.title('ITBids | URLs');
htp.p('</head>');

    for it_rec in itkeywords_cur loop
     second_proc(it_rec.tempkey)

end loop

second_proc (search_term)

CURSOR url_temp_cur IS
SELECT textkey from url_ctx;

BEGIN ctx_query.contains('BG_MAIN_POL',tempkey,'url_ctx');

for url_rec in url_temp_cur loop

INSERT INTO iturls values(url_temp_cur.field_name); end loop;

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jul 20 1999 - 01:22:09 CDT