Home » Developer & Programmer » Forms » HELP-ORA106551
HELP-ORA106551 [message #174259] Fri, 26 May 2006 22:15 Go to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

This command
DDE.Request(ConId, 'R2C6', peril_code ,DDE.CF_TEXT, 10);
results to ORA-106551.
I have declared var peril_code size varchar2(10) and
the data from excel corresponds to that row and column
is less than 10. I can't figure the cause.
Anybody can help me?

[Updated on: Fri, 26 May 2006 22:17]

Report message to a moderator

Re: HELP-ORA106551 [message #174262 is a reply to message #174259] Fri, 26 May 2006 23:33 Go to previous messageGo to next message
rsaluj
Messages: 13
Registered: May 2006
Junior Member
Sorry, we have not yet hear ORA 106551 kindly send the right error
Re: HELP-ORA106551 [message #174265 is a reply to message #174259] Sat, 27 May 2006 00:34 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

Its non-oracle error. It's from a non-stop reading of excel file
and reaches its limit. I have solved the problem.
thanks anyway. Razz
Re: HELP-ORA106551 [message #320417 is a reply to message #174265] Thu, 15 May 2008 01:50 Go to previous messageGo to next message
jale
Messages: 15
Registered: May 2008
Location: TURKEY
Junior Member
Where did you find the non oracle error explanations?

I have ora-106561 non oracle error about DDE
Re: HELP-ORA106551 [message #320461 is a reply to message #320417] Thu, 15 May 2008 03:23 Go to previous messageGo to next message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

I just figured it out. ORA exception with high numbers are non-oracle exceptions. When I encounter this I check processes on OLE,DDE or HOST command lines(these are non-oracle).
Re: HELP-ORA106551 [message #384799 is a reply to message #320461] Thu, 05 February 2009 04:29 Go to previous messageGo to next message
chris9
Messages: 1
Registered: February 2009
Junior Member
Hi Wency,

Please how did you solve the problem beacuse I am facing the same issue.

Regards,
Re: HELP-ORA106551 [message #384951 is a reply to message #384799] Thu, 05 February 2009 21:07 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have a look at http://www.orafaq.com/forum/t/67472/0/

David
Re: HELP-ORA106551 [message #384954 is a reply to message #384799] Thu, 05 February 2009 21:18 Go to previous message
wency
Messages: 450
Registered: April 2006
Location: Philippines
Senior Member

chris,

I said that in my case it was caused by non-stop reading of excel cells. So I put trapping on that, read only cells with data and then if encountered 3 consecutive blanks, I assume I have to exit.

regards,
Wency
Previous Topic: how create shortcut form on desktop
Next Topic: Update from forms
Goto Forum:
  


Current Time: Tue Dec 06 12:24:34 CST 2016

Total time taken to generate the page: 0.11703 seconds