|
|
Choosing A Webhost: |
Script not executed, although Oracle SQLPlus could do it: msg#00041db.squirrel-sql.users
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!
Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV_______________________________________________ Squirrel-sql-users mailing list Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Re: Graph- how to use?, LeO Welsch |
|---|---|
| Next by Date: | Re: Script not executed, although Oracle SQLPlus could do it, Matthew Dahlman |
| Previous by Thread: | Graph- how to use?, LeO Welsch |
| Next by Thread: | Re: Script not executed, although Oracle SQLPlus could do it, Matthew Dahlman |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |