Discussion :

[peuplier]

Bonjour Ca fait plusieurs heures que je cherche mais je ne vois apparaitre aucun résultat dans cette requête

Sur Toad j'ai vue un message qui dit que le dbms_ouput n'est pas activé, qu'à cela ne tienne j'ai immediatement ajouté set serveroutput on size 1000000 rien n'y fait.
Comment peut on activer l'affichage sur le server svp ?

Cordialement

[Garuda]

Dans l'onglet 'DBMSOUTPUT', il faut activer la sortie (desactivé par défaut)

Cf piece_joint et doc en ligne
[quote]
Debug DBMS Output

When debugging in the Editor, a DBMS Output window automatically displays the results of "DBMS_OUTPUT.PUT_LINE()" statements in the editor.
Note: Output only displays after the procedure has completed execution, not while you are single stepping through the code. In the case of nested procedure calls, all procedures must have run to completion before any DBMS Output content is displayed.
The DBMS Output window can be docked with the Watches, Call Stacks and Breakpoints windows, or dragged aside on its own. Grouped together, all of them can be docked at the bottom of the Editor window.
Note: If you have undocked these windows from the bottom one at a time, Toad will not remember that they are undocked. To undock all of the debugging windows at once, double-click the vertical bar to the left of the docked windows.
Disabling DBMS Output

You can disable DBMS Output so that it does not display in the DBMS Output window.


To disable DBMS output

• At the top of the DBMS Output window, click the Enable/Disable toggle button.

• If the button is green, DBMS Output is enabled.
• If the button is red, DBMS output is disabled, and (disabled) appears next to the name of the window.