Re: syntax error

Karsten Schenk wrote:
> I 'm a beginner and I have following question:
> Something seems to be wrong with the syntax of these lines.
> It must be something tiny.
> Can anyone help me?
>
> EXECUTE IMMEDIATE 'SELECT COUNT(*) - COUNT ('|| c || ') AS nulls,
> COUNT(DISTINCT ' || c || ') AS different , COUNT ('||c||') AS total'
> FROM ' || t INTO nulls, different, total;
> EXECUTE IMMEDIATE 'INSERT INTO ' || dest || ' (id, nulls, different,
> total) VALUES ( :1, :2, :3, :4)' USING (id, nulls, different, total);
>
> Thanks in advance
>
> Karsten

You would receive better help if you posted the *exact* error that you're receiving, together with the Oracle and Operating System versions rather than simply saying "something seems to be wrong".

HTH -g Received on Thu Jun 22 2006 - 04:39:12 CDT