Error: ORA-106556 appears when I try to establish connection

Asked By able31 0 points N/A Posted on - 07/19/2011

Hi everybody,

I wish anyone can help me! I want to export information into a spread sheet so I try to establish Connection between Oracle PL/SQL programs and excel, and then I get the error ORA-106556. I have been searching on the web for some topics or solutions related to this error, but I don’t find any solutions.

Thanks in advance for your help, and by the way, the connection’s been set via DDE Initiate.

Able31.

 

• Status: Open
• Question Views: 7103
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By shethkushal 5 points N/A #84094

Error: ORA-106556 appears when I try to establish connection

Cause
~~~~~~~
The reason for this error message is the time taken for the excel application to open up, but prior to that the forms starts communicating which cause the error of ORA-106556 (which means cannot establish connection with DDE).

Fix
~~~~
1. Use a synchronize command between the 2 statements .
2. Or use dbms_lock.sleep(<integer>) to make forms application wait for a while before it starts the communication

About shethkushal

Questions
0

Answers
9

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 07/28/2011
• Question Category: Oracle Database