| ora-106556 [message #277616] |
Tue, 30 October 2007 16:58  |
wdv12345
Messages: 2
Registered: October 2007
Location: Tegucigalpa
|
Junior Member |
|
|
Hey guys!
I hope you can help me! I'm getting this error (ora-106556) when trying to establish connection between oracle (pl/sql program) and excel. I want to export information into a spread sheet.
I've been searching on the web for some topics related to this error, but no solution has been found yet.
Thanks in advance for your support.
By the way, the connection's been set via DDE.Initiate
[Updated on: Tue, 30 October 2007 16:59] Report message to a moderator |
|
|
|
| Re: ora-106556 [message #277617 is a reply to message #277616] |
Tue, 30 October 2007 17:07  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
from 2003
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 snychronize 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
I have NO idea how valid either fix may be but I am just passing them along.
Also:
Oracle Support Bulletins:
-------------------------
10192346.6
WIN: Oracle Forms DDE Example for MS Excel
[Updated on: Tue, 30 October 2007 17:15] by Moderator Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
