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

Ignore sqlplus set define off command #669

Closed
crump32 opened this issue Jan 2, 2014 · 4 comments
Closed

Ignore sqlplus set define off command #669

crump32 opened this issue Jan 2, 2014 · 4 comments

Comments

@crump32
Copy link

@crump32 crump32 commented Jan 2, 2014

When running a sql script I have SET DEFINE OFF; as the first line, when running this it states missing or invalid option, once I remove the line it works just fine. Is there any way to preserve the sqlplus command line calls needed for the script? I do believe dbmaintain has this type of feature where you can run via sqlplus. Anything would help, Thanks!

@axelfontaine
Copy link
Contributor

@axelfontaine axelfontaine commented Jan 2, 2014

This is not supported, as this is a sqlplus-specific command that cannot be run via jdbc.

So unfortunately, you will have to stick to your workaround and remove the line.

Cheers
Axel

@axelfontaine axelfontaine reopened this Jan 13, 2016
@axelfontaine axelfontaine changed the title sqlplus commands not working Ignore sqlplus set define off command Jan 13, 2016
@axelfontaine axelfontaine added this to the Flyway 4.0 milestone Jan 13, 2016
axelfontaine added a commit to flyway/flywaydb.org that referenced this issue Jan 13, 2016
@axelfontaine
Copy link
Contributor

@axelfontaine axelfontaine commented Jan 13, 2016

Fixed.

@bretthodel
Copy link

@bretthodel bretthodel commented Apr 3, 2018

Did this get reverted in version 5? After updating to 5 I got ora-00922 missing or invalid option on my lines containing set define off;

@axelfontaine
Copy link
Contributor

@axelfontaine axelfontaine commented Apr 3, 2018

@bretthodel These commands are implemented in Flyway Pro and Enterprise. See https://flywaydb.org/documentation/database/oracle#sqlplus-commands

Please open a new issue if you hit any problem with those.

@flyway flyway locked as resolved and limited conversation to collaborators Apr 3, 2018
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
3 participants
You can’t perform that action at this time.