Excel VBA Macros - ORA-03113: end-of-communication channel Error after some time

[ManojN]

Hello All,

I have an excel in which the active sheet has 20,000+ select queries in B columns and I have written VBA macro to execute those queries from all the B cells and write it in other rows for every select query. So, I should have 20000 rows of records written in excel. But unfortunately, after some time, I have got an error saying
Run-time error '-2147467259(80004005)':
ORA-03113: end-of-communication channel.

This error occurred at 1488th record. Please can I get help on how to rectify this.

Note: I'm connecting to Oracle 11g Database.

 

[Hui]

ManojN

Firstly, Welcome to the Chandoo.org Forums

I've never seen that error but I'll suggest the following

Check record no 1487, 1488 and 1489 for Blank Values in a field, Strange characters in a Field, Numbers in a Text field, Text in a Number field, anything inconsistant with the previous records


Have you read this post: http://dba-oracle.com/m_ora_03113_end_of_file_on_communications_channel.htm

 

[NARAYANK991]

Hi ,

If your problem is not resolved after you have gone through the link suggested by Hui , post some additional information , as follows :

1. Have you run the macro multiple times , and does it always error out at the 1488th record , or does it error out at random records ?

2. Can you post the line of code which is generating the error , or even better , post the complete code for the macro ?

3. Are the queries the same in all cells in column B or are the queries all different ?

4. If the error always happens at the 1488th record , in addition to posting the code , can you post the contents of the relevant cells of this record ?

Narayan

 

[ManojN]

Hello All,

Sorry for the late reply and thank you for all the support. This problem was due to an infinite loop error and was resolved.