[Squirrel-sql-users] Script not executed, although Oracle SQLPlus could do it

[LeO W. <le...@gm...>]

I am surprised that I cannot execute a script on the SQL although I can do it on the SQL-Plus from Oracle. Has anybody an idea, why that's so?

The included script which fails with the very first line. If I delete it, then I get other ORA-Errors, e.g. below.

Since the ORA-Errors do not refer to any kind of invalid table, I guess there is something wrong with the transfer-process (Java => Oracle).

Has anybody an idea how to make it the right way, so the parsing itself from Oracle does not fail any longer?

:)

LeO




Error: java.sql.SQLException: ORA-06550: line 3, column 24:
PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:

   := . ( @ % ; not null range with default character
, SQL State: 65000, Error Code: 6550
Error occured in:
begin
	     declare
		  v_comparetime 		date

or

Error:	 ORA-00905: missing keyword

SQLState:  42000
ErrorCode: 905

or

Error: java.sql.SQLException: ORA-00900: invalid SQL statement
, SQL State: 42000, Error Code: 900

or

Error: java.sql.SQLException: ORA-00900: invalid SQL statement
, SQL State: 42000, Error Code: 900
Error occured in:
LOOP
 			  	  v_comparetime := v_comparetime + 1/48

-- 
"Ein Herz für Kinder" - Ihre Spende hilft! Aktion: www.deutschlandsegelt.de
Unser Dankeschön: Ihr Name auf dem Segel der 1. deutschen America's Cup-Yacht!