Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ORA-00900: invalid SQL statement - bug in the parser #540

Closed
flyway opened this issue Jun 25, 2013 · 1 comment
Closed

ORA-00900: invalid SQL statement - bug in the parser #540

flyway opened this issue Jun 25, 2013 · 1 comment

Comments

@ghost
Copy link
Collaborator

@ghost ghost commented Jun 25, 2013

Original author: adiGa...@gmail.com (May 26, 2013 04:58:08)

I get this error ""2013-05-20 15:44:28,637 ERROR [Server Startup] apachecommons.ApacheCommonsLog (ApacheCommonsLog.java:51) - com.googlecode.flyway.core.api.FlywayException: Error executing statement at line 6: function bitor(p1 number, p2 number) return number ""2013-05-20 15:44:29,093 ERROR [Server Startup] apachecommons.ApacheCommonsLog (ApacheCommonsLog.java:51) - Caused by java.sql.SQLException: ORA-00900: invalid SQL statement

My .sql file is :

create or replace

package pkg_file_classification is
procedure updateServerInnerFilesClass(in_server_id number);
function bitor(p1 number, p2 number) return number;
end pkg_file_classification;

When I removed empty line and it passed

create or replace package pkg_file_classification is
procedure updateServerInnerFilesClass(in_server_id number);
function bitor(p1 number, p2 number) return number;
end pkg_file_classification;

See http://stackoverflow.com/questions/16648074/ora-00900-invalid-sql-statement-using-flyway?noredirect=1#comment24100962_16648074

Original issue: http://code.google.com/p/flyway/issues/detail?id=500

@crump32
Copy link

@crump32 crump32 commented Jan 6, 2014

The following statement below fails in flyway due to the lack of a space between select and ', I would think this falls in line with the bug being described above as well, any idea if this will be fixed in the next release?

Insert into WEB_WINDOWS_COLUMN
( window_id, object_id, column_id, required, editable, hidden, islink, order_id, dddw_filterable, massive_updatable, copyable)
(select'alert_notifications', 'dw_1', 'WEB_LINK',
0, 0, 0, 0,
3, 1, 0, 1 from dual where not exists (select 1 from WEB_WINDOWS_OBJECTS where window_id='alert_notifications' and object_id='dw_1'));

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant