Question:
How do you execute a stored procedure or function and display the result in TOAD?
Answer:
Navigate to the sp or function in schema browser and highlight it. There is a thunder button "Execute Procedure" up there. Click on it to bring up the dialog where you can provide input parameters.
To see output, you need to do things. First, . First, open a output window by View > DBMS Ouput. Second, in the execute dialog, click "Output Options" link and check "Print OUT arguments/RETURN values to DBMS Output". Now the result will be disaplyed in the DBMS Ouput window after you click OK to execute the sp or function.
Showing posts with label toad database execute procedure. Show all posts
Showing posts with label toad database execute procedure. Show all posts
Thursday, April 2, 2009
Subscribe to:
Posts (Atom)