Skip to Main Content

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!

PLS-00306 wrong number or types of arguments in call to 'PUT_LINE'

thelakbeJun 8 2012 — edited Jul 5 2012
Hi Guys,

I'm practising the plsql workouts,during a anonymous PL/SQL block i got the below error,what the mistake i did ?
declare
v1 employee_290512%rowtype;
cursor c1 is select * from employee_290512;
begin
open c1;
loop
fetch c1 into v1;
exit when c1% notfound;
dbms_output.put_line(v1);
end loop;
end;
{/code}

And i got the below error

Error:

ORA-06550: line 10, column 1:
PLS-00306: wrong number or types of arguments in call to 'PUT_LINE'
ORA-06550: line 10, column 1:
PL/SQL: Statement ignored

/Error.


Please help me on this.

Regards
Thelak                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
This post has been answered by PD81 on Jun 8 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 2 2012
Added on Jun 8 2012
5 comments
19,791 views