Error - Oci_nodata
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > * OCI_NODATA error calling procedure * Want to Advertise Here? Solved * OCI_NODATA error calling procedure * Posted on 2001-01-19 Oracle Database 1 Verified Solution 3 Comments 1,922 Views Last Modified: 2012-06-21 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 0 Question by:vantive Facebook Twitter LinkedIn Google LVL 6 Best Solution byMindphaser Points refunded and moved to PAQ ** Mindphaser - Community Support Moderator ** Go to Solution 3 Comments LVL 6 Overall: Level 6 Oracle Database 1 Message Expert Comment by:zebada2001-01-20 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 0 Message Author Comment by:vantive2001-01-20 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 0 LVL 6 Overall: Level 6 Oracle Database 3 Message Accepted Solution by:Mindphaser2002-05-24 Points refunded and moved to PAQ ** Mindphaser - Community Support Moderator ** 0 Write Comment First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Comment Submit Your Comment By clicking you are agreeing to Experts Exchange's Terms of Use. Featured Post Top 6 Sources for Identifying Threat Actor TTPs Promoted by Recorded Future Understanding your enemy is essential. These six sources w
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Spatial All PlacesDatabaseOracle Database + OptionsSpatial 3 Replies Latest reply on Aug 12, 2016 11:45 AM by Stefan Jager SQL Error: No more data to read from https://www.experts-exchange.com/questions/20041670/OCI-NODATA-error-calling-procedure.html socket Ram C Aug 12, 2016 9:58 AM HiI am facing this error frequently in my spatial database when trying to insert data into the tables. Oracle DB 11.2.0.3, I have gone through the trace files and below is the error I see:ORA-07445: exception encountered: core dump [mdidxid()+3677] [SIGSEGV] [ADDR:0x40] [PC:0x422AF0B] [Address not mapped https://community.oracle.com/thread/3961043 to object] [] ORA-13249: SRID 0 does not exist in MDSYS.CS_SRS table ORA-29400: data cartridge errorError - OCI_NODATA ORA-13203: failed to read USER_SDO_GEOM_METADATA viewThe solution on referring to metalink or google is to check and repopulate the USER_SDO_GEOM_METADATA view. But I see the relevant information is present in the view.Any help or suggestions to check further?ThanksRam I have the same question Show 0 Likes(0) 377Views Tags: none (add) spatial - socket errorContent tagged with spatial - socket error This content has been marked as final. Show 3 replies 1. Re: SQL Error: No more data to read from socket Stefan Jager Aug 12, 2016 10:06 AM (in response to Ram C) Yes: do not use SRID 0. If you do not have a SRID, use null. Like Show 1 Likes(1) Actions 2. Re: SQL Error: No more data to read from socket Ram C Aug 12, 2016 11:10 AM (in response to Stefan Jager) Hi StefanThank you for
'DROP TABLESPACE TEMP;' in a regular database can become excessively slow. The reason behind this is http://orana.info/author/hector-r-madrid/ quite simple, even if the users defaults to a different temporary tablespace there could still be sessions holding temporary segments there. It's just a matter of finding https://trac.osgeo.org/gdal/ticket/5076 them and killing them to free the blocks on the temporary segments and you're good to go.The operation of dropping the temporary tablespace looks like this on error - (more...) ORA-00600 [2663], [12], …. Database Management and Performance Hector R. Madrid | Aug 11, 2016 After not having spotted ORA-00600 for a while a new one showed up. ORA-00600: internal error code, arguments: [2663], [12], [3665664941], [12], [3884717804], [], [], [], [], [], [], []This happened out of the blue after a switchover error - oci_nodata back from a Datagurad environment. Basically this is due to a bug, the patch is already included in 11.2.0.2.0 and 11.2.0.3.0 patch sets, but it is not enabled (more...) ORA-00600 [kdiRelocateCommitted:DBAupd] Database Management and Performance Hector R. Madrid | Dec 9, 2014 This error recently showed up in a 11.2.0.3.0 Enterprise Edition RDBMS on Oracle Enterprise Linux: ORA-00600: internal error code, arguments: [kdiRelocateCommitted:DBAupd], [2126573183], [], [], [], [], [], [], [], [],[], []Incident details in: /u01/app/oracle/diag/rdbms/ ....._ora_5642_i10412.trcAfter the trace file I was able to identify which operation produced the error and identify the specific partition that had problems. The error was triggered during a partitioned index maintenance operation:alter (more...) ORA-12012: error on auto execute of job "SYS"."BSLN_MAINTAIN_STATS_JOB" Database Management and Performance Hector R. Madrid | Jan 22, 2014 Note: This particular scenario happened on an Oracle 11g Rel.2 (11.2.0.3.0) RAC on OEL6 x64 with Active Dataguard.The following error shows on a scheduled basisORCL1:Sat Jan 18 23:00:06 2014Errors in file /u01/app/oracle/diag/r