[mojo-dev] [jira] (MSQL-92) ORA-00911 invalid character error in SQL View query that ends with a ;

[monika c (JIRA)]

monika c commented on MSQL-92 ORA-00911 invalid character error in SQL View query that ends with a ; We are using the below configuration: <delimiter>/</delimiter> <delimiterType>row</delimiterType> We have couple of other scripts for Triggers , Procedures, Packages etc. example Procedure script: CREATE OR REPLACE procedure after_copy is begin null; end; / The above script runs fine. But only in the View script, if we add a semi colon at the end it fails with invalid character error. The exception does not occur from oracle when we execute the same script within oracle. So looks to be somethign wrong happening when the plugin is trying to create the View.

This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira

--------------------------------------------------------------------- To unsubscribe from this list, please visit: http://xircles.codehaus.org/manage_email