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...
BUG: Ora-00933: when inserting new row-data in VS.NET 2010
-
- Posts: 60
- Joined: Mon 18 May 2009 13:17
We thank you for notifying us about the error in our product.
Fix of the error will be included in the next build of OraDeveloper Tools.
Yes, this is a bug.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)
Fix of the error will be included in the next build of OraDeveloper Tools.