Executing a stored procedure in Oracle SQL Developer

Question

I am looking for some help in getting the following stored proc to work: I get anonymous block completed and not able to see the result. It works perfectly fine in PL/SQL devloper's "tes" window, but I would like to see it work in the ORACLE SQL Developer

DECLARE  
TYPE OUTPUT_CURSOR IS REF CURSOR  
t_c OUTPUT_CURSOR  
BEGIN  
P_M.E_S.T_S_QUERY( 123,'ABC','20100101','20100131','ALL',:t_c);    
END;

Are you clicking the "View Script Output" in the output tab at the bottom of the page? I think by default it shows a grid view - which when executing a PL/SQL block wont populate with anything. — diagonalbatman
– diagonalbatman, Commented Jan 9, 2011 at 16:08
No luck with View | Script output, the window is still blak. The "anonymous block coompleted" shows up in the statement output window. I also tried the "+" button, it pops up a "Select connection" dialog but does not show the result. — user85917
– user85917, Commented Jan 9, 2011 at 17:25

Chandu · Accepted Answer · 2011-01-09 16:11:38Z

6

Make sure you enable the DBMS Output using "View->DBMS Output" and clicking "+" button in the resulting window.

answered Jan 9, 2011 at 16:11

Chandu

83.2k19 gold badges136 silver badges136 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

diagonalbatman Over a year ago

ah yes i forgot about that option aswell

Jithin · Accepted Answer · 2013-11-18 08:46:20Z

0

In SQL developer we can see the Stored Procedure output by enabling DBMS OUTPUT. You can go to VIEW menu and find this option. (Don't forget to enable DBMS output for the desired connection by pressing CTRL+N (the + button))

Hope this makes sense. :)

answered Nov 18, 2013 at 8:46

Jithin

1

Collectives™ on Stack Overflow

Executing a stored procedure in Oracle SQL Developer

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related