CODEWITHSUNDEEP
oracle-databasetoad
Stagg
Stagg

Reputation: 2855

How do I get the return value from a function in Oracle using Toad

How do I find out in Toad what the return value of a function is?

I'm running something like this code:

declare r number;
begin
    r:= packagename.functionname(paraname);
end;

I can't work out how to get "r" returned to the data grid, some posts suggest using DBMS output but nothing is written to it when I run the code.

The function performs updates, commits, calls other functions and has cursors in it.

Upvotes: 8

Views: 31170

Answers (3)

Andy F
Andy F

Reputation: 69

The answer from Klaus of

select packagename.functionname(paraname) from dual;

worked for me but it only returned a cursor. This displayed as (CURSOR) in the data grid in Toad. Once I double clicked on that, it opened a new windows with a data grid for that cursor and I saw my results.

Upvotes: 0

Allan
Allan

Reputation: 17429

begin
    dbms_output.put_line(packagename.functionname(paraname));
end;

You'll need to turn output on before running this. To do that, select the "DBMS Output" tab at the bottom of the editor, then click the leftmost button under the tab (it should depict a red circle, with the tooltip "Turn Output On" (if it's a green circle, output is already on)).

The results of the query will be written to the "DBMS Output" window, not the "Data Grid" (you may have to wait a few seconds for the polling to pick up the results). If you use a user-defined type or a ref cursor, this will be insufficient and you'll need to process the results in the anonymous block before writing them out.

Upvotes: 14

Klaus Byskov Pedersen
Klaus Byskov Pedersen

Reputation: 120927

How about just:

select packagename.functionname(paraname) from dual;

Upvotes: 11

Related Questions