<p>Oracle does not support the INSERT INTO ... DEFAULT VALUES syntax used by<br>
SQLMaker by default. Furthermore, Oracle has no way of inserting a row<br>
without specifying any columns, so the only reasonably fix seems to be to<br>
pick a column and supply the DEFAULT keyword as value for it.</p>

<p>This approach seems to work without problems, even for things like<br>
sequence+trigger-as-auto-increment.</p>

<hr>

<h4>You can merge this Pull Request by running</h4>
<pre>  git pull https://github.com/lasse-unity3d/dbix-class oracle-fix-empty-insert</pre>
<p>Or view, comment on, or merge it at:</p>
<p>&nbsp;&nbsp;<a href='https://github.com/dbsrgits/dbix-class/pull/61'>https://github.com/dbsrgits/dbix-class/pull/61</a></p>

<h4>Commit Summary</h4>
<ul>
  <li>Unbreak $rs-&gt;create() with empty hashref on Oracle</li>
</ul>

<h4>File Changes</h4>
<ul>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/dbix-class/pull/61/files#diff-0">lib/DBIx/Class/Storage/DBI/Oracle/Generic.pm</a>
    (15)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/dbix-class/pull/61/files#diff-1">t/60core.t</a>
    (4)
  </li>
  <li>
    <strong>M</strong>
    <a href="https://github.com/dbsrgits/dbix-class/pull/61/files#diff-2">t/73oracle.t</a>
    (6)
  </li>
</ul>

<h4>Patch Links:</h4>
<ul>
  <li><a href='https://github.com/dbsrgits/dbix-class/pull/61.patch'>https://github.com/dbsrgits/dbix-class/pull/61.patch</a></li>
  <li><a href='https://github.com/dbsrgits/dbix-class/pull/61.diff'>https://github.com/dbsrgits/dbix-class/pull/61.diff</a></li>
</ul>

<p style="font-size:small;-webkit-text-size-adjust:none;color:#666;">&mdash;<br>Reply to this email directly or <a href="https://github.com/dbsrgits/dbix-class/pull/61">view it on GitHub</a>.<img alt="" height="1" src="https://github.com/notifications/beacon/302594__eyJzY29wZSI6Ik5ld3NpZXM6QmVhY29uIiwiZXhwaXJlcyI6MTcyNzYzMjg5MiwiZGF0YSI6eyJpZCI6NDQxNzM4ODV9fQ==--eec6bf7aa778c567321b2d3ed72eff538b020335.gif" width="1" /></p>
<script type="application/ld+json">{"@context":"http://schema.org","@type":"EmailMessage","description":"View this Pull Request on GitHub","action":{"@type":"ViewAction","url":"https://github.com/dbsrgits/dbix-class/pull/61","name":"View Pull Request"}}</script>