How to call Microsoft Excel from Oracle Forms 6i

5 pts.
Tags:
Excel 2007
Oracle Forms
Oracle Forms 6i
I have a form that has to put data to excel. The excel file is being created but my problem is the data is failing to insert from oracle to excel. I am using forms 6i. My machine is running Windows 7 Enterprise and office 2010. I have tried it on one with Excel 2007 and it works fine. I am using the DDE package e.g  DOC_ID := DDE.INITIATE('EXCEL', V_PATH||V_FILE);       BEGIN         R := 2;         DDE.POKE(DOC_ID, 'R1C1', 'X', DDE.CF_TEXT, 40000);         DDE.POKE(DOC_ID, 'R1C2', 'Item', DDE.CF_TEXT, 40000);         DDE.POKE(DOC_ID, 'R1C3', 'Description', DDE.CF_TEXT, 40000);         EXCEPTION WHEN OTHERS THEN               :USER_message := '20000 - Error Inserting Data From       Oracle      To Excel '||sqlerrm;       END;

Software/Hardware used:
Oracle Forms 6i
ASKED: March 2, 2011  8:46 AM
UPDATED: March 2, 2011  2:11 PM

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: 3  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
  • Subhendu Sen
    26,090 pointsBadges:
    report
  • carlosdl
    Are you getting errors ? Is your when-others exception handler being called ?
    65,110 pointsBadges:
    report
  • Taps
    [...] URL: How to call Microsoft Excel from Oracle Forms 6i and-office, being-created, data, enterprise, insert-from, problem, put-data, the-data, [...]
    0 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