<div>
Usually (as the name implies) it means there were less rows available than were requested.<br />
<br />
i.e. if the statement: SELECT * FROM employee returns 20 rows of data and a fetch statement was issued that accepted 50 rows was then executed it would return OCI_NODATA.<br />
<br />
Note: the OCI_NODATA error doesn't mean &quot;NO DATA&quot; it actually means that there was LESS data available than requested.<br />
<br />
I could be more specific if you could supply more details.<br />
<br />
Cheers<br />
Paul<br />

</div>


Usually (as the name implies) it means there were less rows available than were requested.

i.e. if the statement: SELECT * FROM employee returns 20 rows of data and a fetch statement was issued that accepted 50 rows was then executed it would return OCI_NODATA.

Note: the OCI_NODATA error doesn't mean "NO DATA" it actually means that there was LESS data available than requested.

I could be more specific if you could supply more details.

Cheers
Paul


<div>
I have already found out what happened.<br />
I had a varchar to data conversion like that:<br />
TO_CHAR(TO_DATE(0101,'MM/Y<wbr />Y'),'MM/YY<wbr />')<br />
<br />
It worked in Oracle 7.3.4 but I have just upgraded my application to Oracle 8i and it doesn't work in that version.<br />
<br />
I just added the literal [...TO_DATE(01/01,'MM/YY')<wbr />...] and it's working fine.<br />
<br />
Thanks for your cooperation<br />
<br />
vantive<br />
<br />

</div>


I have already found out what happened.
I had a varchar to data conversion like that:
TO_CHAR(TO_DATE(0101,'MM/YY'),'MM/YY')

It worked in Oracle 7.3.4 but I have just upgraded my application to Oracle 8i and it doesn't work in that version.

I just added the literal [...TO_DATE(01/01,'MM/YY')...] and it's working fine.

Thanks for your cooperation

vantive



<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am facing the oracle error OCI_NODATA when I try to run a procedure in a package from an external application developed in C.<br />
Has anyone ever seen this error ???<br />
Can help me out ???<br />
<br />
Thanks,<br />
<br />
vantive
</div>
</div>


Hi,

I am facing the oracle error OCI_NODATA when I try to run a procedure in a package from an external application developed in C.
Has anyone ever seen this error ???
Can help me out ???

Thanks,

vantive

* OCI_NODATA error calling procedure *

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.