Re: EXECUTE IMMEDIATE rounds up results

From: DA Morgan <damorgan_at_psoug.org>
Date: Sat, 03 Mar 2007 14:00:59 -0800
Message-ID: <1172959258.933917@bubbleator.drizzle.com>

ar123456_at_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_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org

Received on Sat Mar 03 2007 - 16:00:59 CST