hI SIR, why cursor , record or any collection does not return data into table format directly as return into sql server. it always do we need to print into dbms.ouptut_put.line statement.?
create procedure myrowtype is emprec emp%rowtype; begin select * into emprec from emp; dbms_output.put_line(emprec.sal||emprec.ename); end;/ begin myrowtype(); end;/ sir getting error can you solve it the error displays is ORA-01422: exact fetch returns more than requested number of rows
The best explaination
So nice equalConnect Coach.👍
Mast Video hai ;)
Sir..can u start dba course..
hI SIR, why cursor , record or any collection does not return data into table format directly as return into sql server. it always do we need to print into dbms.ouptut_put.line statement.?
For printing we need to use put lines only
@@EqualConnectCoach Does we always need to print the result. ? I want to just access procedure into my .NET program and want to display Data.
@@ArvindSingh-mj3rb no
create procedure myrowtype
is
emprec emp%rowtype;
begin
select * into emprec
from emp;
dbms_output.put_line(emprec.sal||emprec.ename);
end;/
begin
myrowtype();
end;/
sir getting error can you solve it
the error displays is
ORA-01422: exact fetch returns more than requested number of rows
Stop saying, "nothing but."
"OverHere"😄