Thanks Damian. I tried both statements, with space around the semicolon and without. Both works fine in Oracle SQL Developer 3.1.07. My oracle version is : Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
Jay On Thu, Aug 16, 2012 at 5:31 AM, Damian Steer <[email protected]> wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 15/08/12 21:52, Jayanath Amaranayake wrote: > > Thanks Andy. I tried to use the snap shot but getting the following > > error with Oracle XE 11g. The same code works just fine with MySQL. > > > So you're getting: > > 11:44:17.154 [Thread-1] WARN c.hp.hpl.jena.sdb.sql.SDBConnection - > execUpdate: SQLException > ORA-00911: invalid character > > LOCK TABLE Nodes IN EXCLUSIVE MODE; INSERT INTO Nodes (hash, lex, > lang, datatype, type) > SELECT NNodeTriples.n0 , NNodeTriples.n1 , NNodeTriples.n2 , > NNodeTriples.n3 , NNodeTriples.n4 > FROM NNodeTriples LEFT JOIN Nodes ON (NNodeTriples.n0=Nodes.hash) > WHERE Nodes.hash IS NULL > > Looking at the explanation of ORA-00911 this isn't obvious at all, but > I reckon it's the semicolon. > > Could you try executing the original then the following statement in > toad or sqldeveloper? > > LOCK TABLE Nodes IN EXCLUSIVE MODE ; INSERT INTO Nodes (hash, lex, > lang, datatype, type) > SELECT NNodeTriples.n0 , NNodeTriples.n1 , NNodeTriples.n2 , > NNodeTriples.n3 , NNodeTriples.n4 > FROM NNodeTriples LEFT JOIN Nodes ON (NNodeTriples.n0=Nodes.hash) > WHERE Nodes.hash IS NULL > > (Just adding a space between 'MODE' and ';') > > The original parses fine on my work database, but that may be a > version issue. We're on 11g. > > select * from v$version where banner like 'Oracle%'; > > If both are fine then we'll have to find another way to reproduce the > issue. > > Damian > > > > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.11 (GNU/Linux) > Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ > > iEYEARECAAYFAlAsvgoACgkQAyLCB+mTtymaHQCfQvUlDLc8GrXXs5fU0eq4hNvW > +PsAoKgkSj2ri3nr1WV1YTmoU34R0+Lp > =TUIN > -----END PGP SIGNATURE----- > -- Thank you, Jayanath
