On Thu, Oct 03, 2002 at 04:53:26PM +0200, Wojciech Strza³ka wrote:
> i've got a simple plsql function and this line is wrong:
>
> EXECUTE ''SELECT INTO lp MAX('' || column || '') AS MX FROM '' || table
> || '';'';
>
> with error message:
>
> "parse error at or near 'INTO' "
>
> it seems like it don't recognize SELECT INTO - but what's wrong?
How about
EXECUTE ''SELECT MAX('' || column || '') AS MX INTO lp FROM '' || table
?
Cheers,
Patrick