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.PUT_LINE using FORALL

1567114Sep 21 2015 — edited Sep 22 2015

Hello,

I want to debug messages in the FORALL Loop.Need help as i am getting error message

p_tec_rec is a RECORD TYPE variable

The Syntax is FORALL i in 1..p_tec_rec.COUNT

execute immediate 'call dbms_output.put_line(:1)' using p_tec_rec(i).requisition_header_id;

INSERT INTO AA

Error :

  • Error(1126,6): PL/SQL: SQL Statement ignored (In the DBMS_OUTPUT section)

Oracle Database version:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
This post has been answered by Jarkko Turpeinen on Sep 21 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2015
Added on Sep 21 2015
16 comments
5,054 views