Hi Nicholas,


I am having some trouble creating stored procedures via Sequoia.

Basically, the error in the console is as follows:

Unsupported CREATE statement CREATE OR REPLACE FUNCTION schema.func()

CREATE OR REPLACE FUNCTION is not SQL standard and it is not supported. CREATE FUNCTION does work but the parser will fail if you have a 'OR REPLACE'.

Am I attempting something that is possible or not or is there something I need to be aware of when creating stored procedures?

Which database backend are you using? Is it Oracle?
You can add a feature request in Jira to modify the create request parser to support 'or replace' options in create statements.

Thanks for your feedback,
Emmanuel

--
Emmanuel Cecchet
FTO @ Frog Thinker Open Source Development & Consulting
--
Web: http://www.frogthinker.org
email: [EMAIL PROTECTED]
Skype: emmanuel_cecchet

_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia

Reply via email to