BUG: Ora-00933: when inserting new row-data in VS.NET 2010

BUG: Ora-00933: when inserting new row-data in VS.NET 2010

Postby goethals.f » Thu 24 Jun 2010 08:29

Hello,

I have some problems (since the new Oradeveloper version v2.60.172) when I try to insert new row-data in VS.NET (both the 2008/2010 versions) after done the "retrieve data" command. I got the Ora-00933 (SQL command not properly ended)

Remark: the DB-table is created on a oracle 734 DB, and access with Oracle8 client. --> it throws errors
When I do the exact same on a oracle10g with oracle8 client (or with oracle10 client) --> It succeeded without errors.

So Is there something changed that tha oracle 734 DB is no longer fully supported.


Maybe some more Details



Table SQL:

CREATE TABLE TLG_SCHAARMESHOUDER (
SCHAARMESHOUDER_KEY VARCHAR2(20) NOT NULL,
DIAMETER NUMBER(38) DEFAULT 0 NOT NULL,
CILINDER_TONNAGE NUMBER(38) DEFAULT 0 NOT NULL,
VENTIEL_YN VARCHAR2(1) DEFAULT 'N' NOT NULL,
OPMERKINGEN VARCHAR2(240)
)

And when I try to insert a new (the first) row through oradeveloper in VS.NET with the following info

SCHAARMESHOUDER_KEY = 'S10'
DIAMETER = 350
CILINDER_TONNAGE = 50
VENTIEL_YN = 'Y'
OPMERKINGEN = 'TEST'

--> I get the Ora-00933 error. (Only when doing this on oracle 734)


Can you reproduce this behaviour ?

thx
Fred



PS: is there some way to view the exact INSERT-sql that is tried. I checked all possible logging-options in the oradeveloper-tab, but the "Devart-SQL Log output" does not show any INSERT-sql statements...
goethals.f
 
Posts: 60
Joined: Mon 18 May 2009 13:17

Postby Viktor » Thu 24 Jun 2010 13:55

We thank you for notifying us about the error in our product.
I have some problems (since the new Oradeveloper version v2.60.172) when I try to insert new row-data in VS.NET (both the 2008/2010 versions) after done the "retrieve data" command. I got the Ora-00933 (SQL command not properly ended)

Yes, this is a bug.
Fix of the error will be included in the next build of OraDeveloper Tools.
Viktor
Devart Team
 
Posts: 68
Joined: Thu 06 May 2010 08:12


Return to dbForge for Oracle