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

Asked By 0 points N/A Posted on -
qa-featured

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.

 

SHARE
Answered By 5 points N/A #84094

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

qa-featured

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

Related Questions