OraFAQ Forum: Client Tools » dbms

Home » Other » Client Tools » dbms_output issue

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

dbms_output issue [message #599077]

Tue, 22 October 2013 01:51

IRFANMBAIG
Messages: 14
Registered: August 2013
Location: uae

Junior Member

Hai,

DECLARE
CURSOR C1(V_DEPTNO IN NUMBER)
IS
SELECT * FROM EMP
WHERE DEPTNO=V_DEPTNO;
BEGIN
FOR V_CUR IN C1(10) LOOP
DBMS_OUTPUT.PUT_LINE(V_CUR.ENAME);
END LOOP;
END;
/

Its showing plsql procedure successfully completed with zero errors.when I click dbms_output i cant see output.
Please guide me.

Report message to a moderator

Re: dbms_output issue [message #599080 is a reply to message #599077]

Tue, 22 October 2013 02:03

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And your client tool is?
I think it is a major point to mention to get a correct answer .

Report message to a moderator

Re: dbms_output issue [message #599091 is a reply to message #599080]

Tue, 22 October 2013 03:10

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Did you enable serveroutput in a tool you use? That might be a red button (that should turn green) or similar.

Report message to a moderator

Re: dbms_output issue [message #599108 is a reply to message #599077]

Tue, 22 October 2013 04:47

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

As Michel said, it depends on the client, however this might be worth a read.

Report message to a moderator

Previous Topic:	Export to Excel by each group
Next Topic:	ERD for a schema using sql navigator

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jul 12 17:31:21 CDT 2025