syntax error

From: Karsten Schenk <karsten-schenk_at_gmx.net>
Date: Thu, 22 Jun 2006 11:08:44 +0200
Message-ID: <e7dmjn$rls$03$1@news.t-online.com>

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 Received on Thu Jun 22 2006 - 04:08:44 CDT