Toad World® Forums

problem in 12c with default keyword in insert

— toad 12.5.0.84

create sequence s;

CREATE TABLE t

( x INT DEFAULT s.NEXTVAL PRIMARY KEY,

y VARCHAR2 (30));

insert

into t ( x,y ) values ( default,‘Hello’ );

– the above blows toad oout of the water.

– works great in sqlplus

It works fine for me. Can you be more specific what happens when you try it?

Wonder if 12.5.0.90 which has a newer drop of the parser and is why it works ???

It’s possible. My qp5.dll is dated 4/6/2014.

This parses and formats fine since at least the beginning of 2013 (5.249).

After bombing out and restarting toad, it has not happened again.
J

From: John Dorlon [mailto:bounce-jdorlon@toadworld.com]

Sent: Wednesday, May 21, 2014 16:01

To: toadoraclebeta@toadworld.com

Subject: RE: [Toad for Oracle - Beta Discussion Forum] problem in 12c with default keyword in insert

RE: problem in 12c with default keyword in insert

Reply by John Dorlon

It works fine for me. Can you be more specific what happens when you try it?

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta
notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.

The information contained in this e-mail and in any attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. This message has been scanned for known computer viruses.