CODEWITHSUNDEEP
sqloracle-database
user85917
user85917

Reputation: 1005

Executing a stored procedure in Oracle SQL Developer

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;

Upvotes: 2

Views: 19889

Answers (2)

Jithin
Jithin

Reputation: 1

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. :)

Upvotes: 0

Chandu
Chandu

Reputation: 82893

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

Upvotes: 6

Related Questions