Discussion :

[yasstunisien]

bonjour,
j'ai eu une lenteur d'exécution d'un programme utilisant CLIENT_OLE2 pour exporter 53 lignes vers excel.

avez vous une idée.

Merci

[Siegduk]

Bonjour yasstunisien,

as-tu fait un tour de ce côté? => https://forums.oracle.com/forums/thr...readID=2147994

J'ai vu qu'il y avait une longue discussion avec plusieurs tests possibles.

Bon courage.

[SheikYerbouti]

Sinon, il y a moyen de créer des fichiers excel depuis du code PL/SQL:
http://sanjeev-oracle-world.blogspot...lsql-code.html

[yasstunisien]

bonjour,

merci pour tous.

malgré la lenteur de client_OLE2 qui fonctionne sous Jinitiator mais au niveau plugin sun le composant OLE2 génère des erreurs.

Java Plug-in 1.5.0_08
Utilisation de la version JRE 1.5.0_08 Java HotSpot(TM) Client VM
Répertoire d'accueil de l'utilisateur = C:\Documents and Settings\Yassine Manai


----------------------------------------------------
c: effacer la fenêtre de la console
f: finaliser les objets de la file d'attente de finalisation
g: libérer la mémoire
h: afficher ce message d'aide
l: vider la liste des chargeurs de classes
m: imprimer le relevé d'utilisation de la mémoire
o: déclencher la consignation
p: recharger la configuration du proxy
q: masquer la console
r: recharger la configuration des politiques
s: vider les propriétés système et déploiement
t: vider la liste des threads
v: vider la pile des threads
x: effacer le cache de chargeurs de classes
0-5: fixer le niveau de traçage à <n>
----------------------------------------------------

RegisterWebUtil - Loading WebUtil Version 1.0.5 Production
java.lang.NoSuchMethodException: sun.java2d.SunGraphicsEnvironment.setFallbackFont(java.lang.String)
at java.lang.Class.getMethod(Unknown Source)
at oracle.forms.engine.Main.initDesktop(Unknown Source)
at oracle.forms.engine.Main.start(Unknown Source)
at sun.applet.AppletPanel.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
java.lang.NoSuchMethodException: sun.java2d.SunGraphicsEnvironment.preferLocaleSpecificFonts()
at java.lang.Class.getMethod(Unknown Source)
at oracle.forms.engine.Main.initDesktop(Unknown Source)
at oracle.forms.engine.Main.start(Unknown Source)
at sun.applet.AppletPanel.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)
proxyHost=null
proxyPort=0
connectMode=HTTP, native.
La version Forms Applet est : 9.0.4.0
2011-déc.-14 11:32:42.31 WUI[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2011-déc.-14 11:32:42.31 WUF[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2011-déc.-14 11:32:42.46 WUH[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2011-déc.-14 11:32:42.46 WUS[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2011-déc.-14 11:32:42.46 WUT[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2011-déc.-14 11:32:42.46 WUO[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2011-déc.-14 11:32:42.62 WUL[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2011-déc.-14 11:32:42.62 WUB[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2011-déc.-14 11:32:42.359 WUT[setProperty()] Setting property WUC_GET_LOCAL_PROPERTY to syslib.jacob.dll
2011-déc.-14 11:32:42.359 WUT[getProperty()] Getting property WUC_GET_LOCAL_PROPERTY
2011-déc.-14 11:32:42.359 WUT[loadSettings()] Local properties file loaded
2011-déc.-14 11:32:42.359 WUT[setProperty()] Setting property WUC_GET_LOCAL_PROPERTY to syslib.JNIsharedstubs.dll
2011-déc.-14 11:32:42.375 WUT[getProperty()] Getting property WUC_GET_LOCAL_PROPERTY
2011-déc.-14 11:32:42.375 WUT[setProperty()] Setting property WUC_GET_LOCAL_PROPERTY to syslib.d2kwut60.dll
2011-déc.-14 11:32:42.375 WUT[getProperty()] Getting property WUC_GET_LOCAL_PROPERTY
2011-déc.-14 11:32:46.500 WUI[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2011-déc.-14 11:32:46.500 WUF[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2011-déc.-14 11:32:46.500 WUH[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2011-déc.-14 11:32:46.500 WUS[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2011-déc.-14 11:32:46.500 WUT[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2011-déc.-14 11:32:46.500 WUO[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2011-déc.-14 11:32:46.500 WUL[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2011-déc.-14 11:32:46.500 WUB[VBeanCommon.findLocalHost()] obtaining LocalHost info from InetAddress
2011-déc.-14 11:32:46.875 WUT[setProperty()] Setting property WUC_GET_LOCAL_PROPERTY to syslib.jacob.dll
2011-déc.-14 11:32:46.875 WUT[getProperty()] Getting property WUC_GET_LOCAL_PROPERTY
2011-déc.-14 11:32:46.890 WUT[setProperty()] Setting property WUC_GET_LOCAL_PROPERTY to syslib.JNIsharedstubs.dll
2011-déc.-14 11:32:46.890 WUT[getProperty()] Getting property WUC_GET_LOCAL_PROPERTY
2011-déc.-14 11:32:46.890 WUT[setProperty()] Setting property WUC_GET_LOCAL_PROPERTY to syslib.d2kwut60.dll
2011-déc.-14 11:32:46.890 WUT[getProperty()] Getting property WUC_GET_LOCAL_PROPERTY
2011-déc.-14 11:32:52.31 WUO[setProperty()] Setting property WUO_OLE2_OBJNAME to Excel.Application
2011-déc.-14 11:32:52.46 WUO[getProperty()] Getting property WUO_OLE2_CREATE_OBJ
2011-déc.-14 11:32:52.343 WUO[setProperty()] Setting property WUO_OLE2_HANDLE to 1
2011-déc.-14 11:32:52.359 WUO[setProperty()] Setting property WUO_OLE2_PROPNAME to Visible
2011-déc.-14 11:32:52.359 WUO[setProperty()] Setting property WUO_OLE2_SET_PROPERTY to SFalse
2011-déc.-14 11:32:52.375 WUO[setProperty()] Setting property WUO_OLE2_HANDLE to 1
2011-déc.-14 11:32:52.375 WUO[setProperty()] Setting property WUO_OLE2_PROPNAME to Workbooks
2011-déc.-14 11:32:52.375 WUO[getProperty()] Getting property WUO_OLE2_GET_OBJ_PROPERTY
2011-déc.-14 11:32:52.468 ERROR>WUO-714 [OleFunctions.setExceptionValues()] Impossible daccéder au detail de la dernière erreur OLE ; Exception
{1}
2011-déc.-14 11:33:04.296 ERROR>WUO-708 [OleFunctions.get_obj_property()] Impossible de lire la propriété: Workbooks; Exception
com.jacob.com.ComFailException: A COM exception has been encountered:
At Invoke of: Workbooks
Description: An unknown COM error has occured.
2011-déc.-14 11:33:56.265 WUI[VBeanCommon.destroy()] WebUtil GetClientInfo Utility being removed..
2011-déc.-14 11:33:56.265 WUI[VBeanCommon.destroy()] 0 out of 0 object references removed, 0 (total) global references outstanding
2011-déc.-14 11:33:56.265 WUF[VBeanCommon.destroy()] WebUtil Client Side File Functions being removed..
2011-déc.-14 11:33:56.265 WUF[VBeanCommon.destroy()] 0 out of 0 object references removed, 0 (total) global references outstanding
2011-déc.-14 11:33:56.265 WUH[VBeanCommon.destroy()] WebUtil Client Side Host Commands being removed..
2011-déc.-14 11:33:56.265 WUH[VBeanCommon.destroy()] 0 out of 0 object references removed, 0 (total) global references outstanding
2011-déc.-14 11:33:56.265 WUS[VBeanCommon.destroy()] WebUtil Session Monitoring Facilities being removed..
2011-déc.-14 11:33:56.265 WUS[VBeanCommon.destroy()] 0 out of 0 object references removed, 0 (total) global references outstanding
2011-déc.-14 11:33:56.265 WUT[VBeanCommon.destroy()] WebUtil File Transfer Bean being removed..
2011-déc.-14 11:33:56.265 WUT[VBeanCommon.destroy()] 0 out of 0 object references removed, 0 (total) global references outstanding
2011-déc.-14 11:33:56.265 WUO[VBeanCommon.destroy()] WebUtil Client Side Ole Functions being removed..
2011-déc.-14 11:33:56.265 WUO[VBeanCommon.destroy()] 1 out of 1 object references removed, 0 (total) global references outstanding
2011-déc.-14 11:33:56.265 WUL[VBeanCommon.destroy()] WebUtil C API Functions being removed..
2011-déc.-14 11:33:56.265 WUL[VBeanCommon.destroy()] 0 out of 0 object references removed, 0 (total) global references outstanding
2011-déc.-14 11:33:56.375 WUB[VBeanCommon.destroy()] WebUtil Browser Functions being removed..
2011-déc.-14 11:33:56.375 WUB[VBeanCommon.destroy()] 0 out of 0 object references removed, 0 (total) global references outstanding