Editing API:EPrints/Database/Oracle (section)

==DESCRIPTION==
Oracle database wrapper for Oracle DB version 9+.

<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>
<span style='display:none'>User Comments</span>
<!-- Edit below this comment -->


<!-- Pod2Wiki= -->
</div>
<!-- Pod2Wiki=head_synopsis -->
===Synopsis===
These settings are the default settings for the free Oracle developer version:

    # Oracle driver settings for database.pl
    $c-&gt;{dbdriver} = "Oracle";
    $c-&gt;{dbhost} = "localhost";
    $c-&gt;{dbsid} = "XE;
    $c-&gt;{dbuser} = "HR";
    $c-&gt;{dbpass} = "HR";
  
<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>
<span style='display:none'>User Comments</span>
<!-- Edit below this comment -->


<!-- Pod2Wiki= -->
</div>
<!-- Pod2Wiki=head_setting_up_oracle -->
===Setting up Oracle===
Enable the HR user in Oracle XE.

Set the <tt>ORACLE_HOME</tt> and <tt>ORACLE_SID</tt> environment variables. To  add these globally edit <tt>/etc/profile.d/oracle.sh</tt> (for XE edition):

  export ORACLE_HOME="/usr/lib/oracle/xe/app/oracle/product/10.2.0/server"
  export ORACLE_SID="XE"
  
(Will need to relog to take effect)

<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>
<span style='display:none'>User Comments</span>
<!-- Edit below this comment -->


<!-- Pod2Wiki= -->
</div>
<!-- Pod2Wiki=head_oracle_specific_annoyances -->
===Oracle-specific Annoyances===
Use the GQLPlus wrapper from http://gqlplus.sourceforge.net/ instead  of sqlplus.

Oracle will uppercase any identifiers that aren't quoted and is case  sensitive, hence mixing quoted and unquoted identifiers will lead to  problems.

Oracle does not support <tt>LIMIT()</tt>.

Oracle does not support <tt>AUTO_INCREMENT</tt> (MySQL) nor <tt>SERIAL</tt>  (Postgres).

Oracle won't <tt>ORDER BY LOBS</tt>.

Oracle requires special means to insert values into <tt>CLOB</tt>/<tt>BLOB</tt>.

Oracle doesn't support <tt>AS</tt> when aliasing.

When specifying char column lengths use (n char) to define character  semantics. Otherwise oracle uses the <tt>nls_length_semantics</tt> setting  to determine whether you meant bytes or characters.

{{API:PodLink|file=DBD/Oracle|package_name=DBD::Oracle|section=|text=DBD::Oracle}} can crash when using <tt>PERL_USE_SAFE_PUTENV</tt>-compiled  Perls, see http://www.eprints.org/tech.php/13984.html.

<div style='background-color: #e8e8f; margin: 0.5em 0em 1em 0em; border: solid 1px #cce;  padding: 0em 1em 0em 1em; font-size: 80%; '>
<span style='display:none'>User Comments</span>
<!-- Edit below this comment -->


<!-- Pod2Wiki= -->
</div>
<!-- Pod2Wiki=head_constants -->