Re: pl\sql. Test API?

jimi_xyz_at_hotmail.com wrote:
> Dear Mr. Bakker,
> I knew you would dig into one of my posts, sooner or later. Anyways
> Where exactly should i put the cursor declaration? Also, im using a
> temporary table because im not quite sure on how to send the score and
> projectID number back to the front ASP program? Im open to any ideas
> with some examples. One last thing how do i go about placing the
> VARCHAR search_string in the where contains clause, instead of the hard
> wired word 'research'?

A cursor declaration belongs after BEGIN at the beginning of a block. For examples www.psoug.org, click on Morgan's Library, click on CURSORs.

Stop using temporary tables ... period. They are a lousy substitute on other SQL implementations required by their transaction model. In Oracle there is no excuse for creating them ... EVER!

If you don't know how to send something back ... then ask.

But before you ask look in Morgan's Library for REF CURSOR.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)