Re: How do I get query result(select e.g.) from a dynamic command(EXECUTE)?

On Thursday 19 February 2004 11:50, Wei Wang wrote:
> Hi,
>
> I want to do a select in dynamic command, something like:
>
[snip]
> I know that SELECT INTO doesn't support dynamic command, EXECUTE does. But
> if I EXECUTE a select query, how do I get
> the select result from it?


FOR record | row IN EXECUTE text_expression LOOP
    statements
END LOOP;

It's in the manuals, but that's about all they say on the subject
--
  Richard Huxton
  Archonet Ltd