execute immediate 'insert into ...'
- From: "Joe Smith" <joe_dba@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 09 Sep 2005 09:31:13 -0500
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/
--
//www.freelists.org/webpage/oracle-l
Other related posts: