Home > IT Answers > Microsoft Windows > How to call Microsoft Excel from Oracle Forms 6i
Taps
5 pts.
 How to call Microsoft Excel from Oracle Forms 6i
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
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 
Subhendu Sen
 22,035 pts.
 

Are you getting errors ?
Is your when-others exception handler being called ?

carlosdl
 63,535 pts.