DbUp / dbup-oracle

Oracle provider for DbUp
MIT License
2 stars 5 forks source link

dbup-oracle - Error Attempting to Create or Replace Package due custom delimiter/OracleDatabaseWithDefaultDelimiter does not honor newline #1

Open dagr8anil opened 2 years ago

dagr8anil commented 2 years ago

Hi everyone, When using OracleDatabaseWithDefaultDelimiter or OracleDatabase (with char delimiter parameter), it incorrectly splits the SQL statement in my package body. Example attached via linqpad script. I think the best fix would be to make OracleDatabase (with char delimiter parameter) into a string delimiter (and change the inner methods to honor the string delimiter)

Bug Capture

Potential fix image

dagr8anil commented 2 years ago

i dont mind making the fix myself as a contributor.

mjauernig commented 1 year ago

Can you make a pull request? Thank you in advance.