<p>I just happened upon this problem.  I boiled it down to this reproduction:</p>
<pre><code>$  echo "drop table foo;" |sqlt -f Oracle -t SQLite
       ERROR (line 1): Invalid statement: Was expecting remark, or run, or
                       prompt, or create, or table comment, or comment on
                       table, or comment on column, or alter, or drop
Error: translate: Error with parser 'SQL::Translator::Parser::Oracle': Parse failed.
</code></pre>
<p>Replace "Oracle" with "SQLite" and it works.</p>
<p>Changing WORD(s) to WORD in the line noted previously made it work, though I'm not sure that's the correct solution.</p>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br />You are receiving this because you are subscribed to this thread.<br />Reply to this email directly, <a href="https://github.com/dbsrgits/sql-translator/issues/89#issuecomment-451315983">view it on GitHub</a>, or <a href="https://github.com/notifications/unsubscribe-auth/AASeAhB9bQr2jLKg_BElNXHOWUdXOi2Aks5u_phugaJpZM4NLfkx">mute the thread</a>.<img src="https://github.com/notifications/beacon/AASeAilUY25P0kWSIBAWOfcTAkzE-0Qpks5u_phugaJpZM4NLfkx.gif" height="1" width="1" alt="" /></p>
<script type="application/json" data-scope="inboxmarkup">{"api_version":"1.0","publisher":{"api_key":"05dde50f1d1a384dd78767c55493e4bb","name":"GitHub"},"entity":{"external_key":"github/dbsrgits/sql-translator","title":"dbsrgits/sql-translator","subtitle":"GitHub repository","main_image_url":"https://github.githubassets.com/images/email/message_cards/header.png","avatar_image_url":"https://github.githubassets.com/images/email/message_cards/avatar.png","action":{"name":"Open in GitHub","url":"https://github.com/dbsrgits/sql-translator"}},"updates":{"snippets":[{"icon":"PERSON","message":"@trentfisher in #89: I just happened upon this problem.  I boiled it down to this reproduction:\r\n\r\n```\r\n$  echo \"drop table foo;\" |sqlt -f Oracle -t SQLite\r\n       ERROR (line 1): Invalid statement: Was expecting remark, or run, or\r\n                       prompt, or create, or table comment, or comment on\r\n                       table, or comment on column, or alter, or drop\r\nError: translate: Error with parser 'SQL::Translator::Parser::Oracle': Parse failed.\r\n```\r\nReplace \"Oracle\" with \"SQLite\" and it works.\r\n\r\nChanging WORD(s) to WORD in the line noted previously made it work, though I'm not sure that's the correct solution."}],"action":{"name":"View Issue","url":"https://github.com/dbsrgits/sql-translator/issues/89#issuecomment-451315983"}}}</script>
<script type="application/ld+json">[
{
"@context": "http://schema.org",
"@type": "EmailMessage",
"potentialAction": {
"@type": "ViewAction",
"target": "https://github.com/dbsrgits/sql-translator/issues/89#issuecomment-451315983",
"url": "https://github.com/dbsrgits/sql-translator/issues/89#issuecomment-451315983",
"name": "View Issue"
},
"description": "View this Issue on GitHub",
"publisher": {
"@type": "Organization",
"name": "GitHub",
"url": "https://github.com"
}
}
]</script>