SGA Trace/Optimization | Export Dataset to Excel | check “Include SQL Statement”

Tchater maintenant avec le support

SGA Trace/Optimization | Export Dataset to Excel | check “Include SQL Statement” | file is empty. (4290341)

Retour

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Titre

SGA Trace/Optimization | Export Dataset to Excel | check “Include SQL Statement” | file is empty.
Description

SGA Trace/Optimization | Export Dataset to Excel File | check mark “Include SQL Statement” | the generated Excel file is empty or blank.

If exported to “Delimited Text” and also check mark “Include SQL Statement”, the error received is “List index out of bounds (-1)”. The Text file is still generated, but it is also empty.
Cause

The “Include SQL Statement” should not be checked. This option should have been disabled for this particular export.
Résolution

WORKAROUND:

Un-check the “Include SQL Statement” box.

STATUS:

Waiting for fix in a future release of Toad for Oracle.
Identifiant du défaut

CR113858
Informations supplémentaires

The Toad Developers explained that the “Include SQL Statement” option should not have been enabled to begin with. This issue will be fixed in a future release. The main defect here is that the checkbox is enabled when it should not be. The issue is from when Toad executes a query to load that grid, but the cursor is closed immediately after the grid is loaded, so the "Export Dataset" dialog does not have access to it. If the user wants to see the query, he/she can turn on Spool SQL.

Commentaire envoyé

Cet article vous a-t-il à résoudre un problème ?

Sélectionner une évaluation

Contenu recommandé

Historique de l’article :: Créé le : 2/20/2014
Dernière mise à jour le : 5/7/2023

SGA Trace/Optimization | Export Dataset to Excel | check “Include SQL Statement” | file is empty. (4290341)