"Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> However, because PERFORM discards the results of a query it is only
> useful for side effects of the query. My usage of it was wrong since I
> wasn't using it for side effects merely for determining the existance
> of a result without having to store that result since it wasn't
> required. Therefore, with the correct syntax of PERFORM <query> my
> function doesn't generate an 'unprogrammed' error but the test of
> FOUND always fails, i.e. result is NOT FOUND. Therefore SELECT INTO
> dummy ... is still the correct thing for me to be doing.
Okay. I guess the next question is whether PERFORM *should* be setting
FOUND. Seems like it might be a reasonable thing to do.
Does PERFORM exist in Oracle's plsql? If so, what does it do?
regards, tom lane