Path: news.f.de.plusline.net!news-fra1.dfn.de!news0.de.colt.net!newsfeed.r-kom.de!newsfeed.freenet.de!newspeer1.nwr.nac.net!border2.nntp.dca.giganews.com!nntp.giganews.com!cyclone1.gnilink.net!gnilink.net!nx01.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail Date: Sat, 03 Mar 2007 14:00:59 -0800 From: DA Morgan Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 1.5.0.10 (Windows/20070221) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.misc Subject: Re: EXECUTE IMMEDIATE rounds up results References: <1172940527.424176.63210@31g2000cwt.googlegroups.com> <1172942753.498202@bubbleator.drizzle.com> <1172950717.684440.266470@p10g2000cwp.googlegroups.com> <45E9D7C6.8080402@gmail.com> <1172956107.465366.144280@p10g2000cwp.googlegroups.com> In-Reply-To: <1172956107.465366.144280@p10g2000cwp.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <1172959258.933917@bubbleator.drizzle.com> Cache-Post-Path: bubbleator.drizzle.com!unknown@oracle.advtechserv.com X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 22 X-Complaints-To: abuse@csolutions.net Xref: news.f.de.plusline.net comp.databases.oracle.misc:78437 ar123456@gmail.com wrote: > We are using Oracle 9.2.0.4.0, we are using Toad to connect to the > system, we tried original code (not this test one) from sqlplus. I > suppose it may be patched already. > > Thanks It is likely a TOAD problem and perhaps because your version doesn't support the TIMESTAMP data type. Sure am glad I asked you for the real code. I'd have never figured out what you were referring to from your original. PS: 9.2.0.4 is about 4 patches behind. You might want to do that before desupport begins in 3 months. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org