EXECUTE IMMEDIATE and dynamic inserts

From: Christian <ccote_msl_at_yahoo.com>
Date: 11 Jan 2002 04:09:36 -0800
Message-ID: <992a9b5a.0201110409.18769c60@posting.google.com>

HI,
I want to use NDS to execute this kind of DML :

v_Fields  VARCHAR2(25);
v_Values  VARCHAR2(50);
v_SqlStmt VARCHAR2(100);

acct_Rec SCOTT.Account%ROWTYPE;

BEGIN
  v_Fields := 'BALANCE, ACCOUNTNO';
  v_Values := 'acct_Rec.BALANCE, acct_Rec.ACCOUNTNO';

  v_SqlStmt := 'INSERT INTO SCOTT.ACCOUNT ('||v_Fields||') VALUES ('||v_Fields||')';

EXECUTE IMMEDIATE v_SqlStmt;
END;
 I get the following error : "ORA-00984: column not allowed here"

I need to dynamically generate the fields values and their values. I know that I can do it in Visual Basic easily. Is there a way to accomplish this in PL/SQL?

Thank you for your help,
Christian Received on Fri Jan 11 2002 - 06:09:36 CST