Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_OUTPUT

487726Jul 26 2006 — edited Jul 27 2006
Hello All,

I have few questions:

1 . I have created a procedure in which I have few update statements and few DBMS_OUTPUT.PUT_LINE() statements. When I run a procedure in SQL plus I can see the result of DBMS_output statements.

How do I see the bdms_output result when I execute the procedure in TOAD.?

2. Can anyone tell me when to use anonymous procedure and when to named procedure


3. When I have manipulations of each of the row of a table. Is it good to use loop within a cursor to perform the manipulaiton or is it better to create one or more temp tables perform the manipulation with few SQL statements.

Thanks in advance,
Ac
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 24 2006
Added on Jul 26 2006
2 comments
231 views