Can I use then Forms 6i DDE build-in package to generate 2010 EXCEL File?

5 pts.
Tags:
excel
Oracle Forms
Oracle Forms 6i
PL/SQL
Hi all, My company' application is used Oracle FORMS 6i Solution,Client /Server environment to generated EXCEL file I coding the PL/SQL in the Oracle FORM, it's succeed generated EXCEL file in MS office Excel 2007/2003/2000. Now I have problem in MS office Excel 2010. It's just opening the Excel file but no data can be written into the Excel file, It's always raise the error exception:

"dde.dmlerr_no_conv_established" some one can help me,thanks !! my pl/sql code wrote in Button Item's trigger WHEN-BUTTON-PRESSED [hr /> declare obj ole2.obj_type; path varchar2(256); p_excel_path varchar2(255); appid pls_integer; convid pls_integer; begin begin obj := ole2.create_obj('excel.application'); path := ole2.get_char_property(obj,'path'); ole2.release_obj(obj); ole2.invoke(obj,'quit'); exception when others then message('office excel not found!'); return; end; p_excel_path := path||'excel.exe'; synchronize; appid := dde.app_begin(p_excel_path, dde.app_mode_normal); dde.app_focus(appid); convid := dde.initiate('excel','book1');

dde.poke(convid,'r1c1','abc',dde.cf_text,100000); dde.poke(convid,'r2c2','abc',dde.cf_text,100000); exception when dde.dmlerr_no_conv_established then message('dmlerr_no_conv_established'); raise form_trigger_failure; when others then null; end;



Software/Hardware used:
oracle forms 6i

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    I've never tried it with Excel 2010, but it seems that the conversation is not being established. Check the value of your 'convid' variable after this line:
    convid := dde.initiate('excel','book1'); 
    Without a valid conversation ID all subsequent calls to poke will fail. This is most likely going to need investigation on the Excel side, as something must have been changed in its DDE server.
    68,495 pointsBadges:
    report
  • Darryn
    It could simply be that the "Ignore other applications" has been selected in the Advanced Options settings in Excel. Clear this selection and try again.
    765 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following