Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » dde begin (xp , office 2007 , oracle fusion middelware )
dde begin [message #452325] Wed, 21 April 2010 05:57
jihad
Messages: 4
Registered: May 2009
Junior Member
Dear ALL,

i m using oracle fusion middleware ,webutil , win xp and office 2007.

this function create an excel file in C:\MISOUT
Function F_Create_File ( p_FileName In Varchar2 ) Return Number Is
v_TxtFileID Text_Io.File_Type;
Begin
v_TxtFileID := Text_Io.FOpen(p_FileName,'w' );
If Text_IO.Is_Open(v_TxtFileID) Then Text_IO.FClose(v_TxtFileID); End If;
Return (1);
EXCEPTION WHEN OTHERS THEN
Return (-1);
End F_Create_File;

GOING TO WINDOWS C:\MISOUT I SEE THE FILE CREATED BUT WHEN I TRY TO OPEN IT A MESSAGE FROM MICROSOFT OFFICE EXCEL "EXCEL CANNOT OPEN THE FILE BECAUSE THE FILE FORMAT OR EXTENSION IS NOT VALID.VERIFY THAT THE FILE IS NOT CORRUPTEDAND THE EXTENSION MATCH THE FORMAT OF THE FILE"

THE EXTENSION IS XLSX AND IT IS RIGHT IN IN ORACLE
vFileName VARCHAR2(50):= GLOBAL_VAR.MISOUT ||
SUBSTR(:INVOICE,2, ||'.xlsx ';


WHY I CANOT OPEN THE FILE , SO I CAN LATER LOAD DATA FROM ORACLE INTO THE FILE USING DDE.APP_BEGIN
thank you .
Previous Topic: Windows ISS(To host form) Error
Next Topic: how URL is assigned to different users when forms apps is launched?
Goto Forum:
  


Current Time: Tue Sep 16 15:12:42 CDT 2014

Total time taken to generate the page: 0.10995 seconds