<HTML ><HEAD ><TITLE >Ora_Error</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="PHP Manual" HREF="index.html"><LINK REL="UP" TITLE="Oracle functions" HREF="ref.oracle.html"><LINK REL="PREVIOUS" TITLE="Ora_Do" HREF="function.ora-do.html"><LINK REL="NEXT" TITLE="Ora_ErrorCode" HREF="function.ora-errorcode.html"><META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=ISO-8859-1"></HEAD ><BODY CLASS="refentry" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PHP Manual</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.ora-do.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.ora-errorcode.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.ora-error" ></A >Ora_Error</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN69201" ></A ><P > (PHP 3, PHP 4 )</P >Ora_Error -- get Oracle error message</DIV ><DIV CLASS="refsect1" ><A NAME="AEN69204" ></A ><H2 >Description</H2 >string <B CLASS="methodname" >Ora_Error</B > ( int cursor_or_connection)<BR ></BR ><P > Returns an error message of the form <TT CLASS="replaceable" ><I >XXX</I ></TT >-<TT CLASS="replaceable" ><I >NNNNN</I ></TT > where <TT CLASS="replaceable" ><I >XXX</I ></TT > is where the error comes from and <TT CLASS="replaceable" ><I >NNNNN</I ></TT > identifies the error message. </P ><P > <DIV CLASS="note" ><BLOCKQUOTE CLASS="note" ><P ><B >Note: </B >Support for connection ids was added in 3.0.4.</P ></BLOCKQUOTE ></DIV > </P ><P > On UNIX versions of Oracle, you can find details about an error message like this: <TT CLASS="computeroutput" > $ <TT CLASS="userinput" ><B >oerr ora <TT CLASS="replaceable" ><I >00001</I ></TT ></B ></TT > 00001, 00000, "unique constraint (%s.%s) violated" // *Cause: An update or insert statement attempted to insert a duplicate key // For Trusted ORACLE configured in DBMS MAC mode, you may see // this message if a duplicate entry exists at a different level. // *Action: Either remove the unique restriction or do not insert the key </TT > </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="function.ora-do.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="function.ora-errorcode.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Ora_Do</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="ref.oracle.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Ora_ErrorCode</TD ></TR ></TABLE ></DIV ></BODY ></HTML >