Skip to Main Content

Oracle Forms

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.put_line

cocoMay 14 2008 — edited May 14 2008
Hi,

Knows someone how can I use dbms_output.put_line in oracle forms?
I wrote on "when the button pressed" the following:
DECLARE
CURSOR c_firme IS select codfirma, denfirma, loc from firme where zona='BANAT';

BEGIN
DBMS_OUTPUT.PUT_LINE('Lista cu firmele din Banat: ');

FOR rec_firme IN c_firme LOOP
DBMS_OUTPUT.PUT_LINE('Firma ' ||rec_firme.denfirma|| ' este din localitatea: '||rec_firme.loc);
END LOOP;
END;

but I have no results.
In Sql I have the results.

Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 11 2008
Added on May 14 2008
5 comments
1,306 views