Home » Open Source » Programming Interfaces » ora-106556
ora-106556 [message #277616] Tue, 30 October 2007 16:58 Go to next message
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 Go to previous message
BlackSwan
Messages: 22792
Registered: January 2009
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

Previous Topic: SQLJ Error
Next Topic: retrieving CLOB from an Oracle stored function within perl
Goto Forum:
  


Current Time: Sun Sep 21 05:22:28 CDT 2014

Total time taken to generate the page: 0.15649 seconds