execute immediate 'insert into ...'

From: Joe Smith <joe_dba_at_hotmail.com>
Date: Fri, 09 Sep 2005 09:31:13 -0500
Message-ID: <BAY107-F31C7DBA4BAAC35D078075497980@phx.gbl>

I am trying to insert records into a table through execute immediate. The number datatypes go in with no problem. It is the varchar2 and date formats that are giving me a problem.

examples:

desc tables test
col1 number,
col2 varchar2(30)
col3 date

execute immediate 'insert into test values ('|| 2 ||', '|| joe ||', '|| 07-JUN-05 ||')'; I have tried different ways to format the varchar2 and date datatype, but keeps giving me an error.

How do I format these datatypes within an execute immediate?

thanks.

---

Express yourself instantly with MSN Messenger! Download today - it's FREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Sep 09 2005 - 09:33:18 CDT