By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table data6
(
id integer,
d5 date,
d2 varchar(10)
);
insert into data6 values (1, sysdate, 'foobar');
1 rows affected
create or replace procedure test(doc_id number)
as
l_text varchar(500);
begin
select 'Test'||to_char(d5,'yy.mm.dd')||chr(10)||chr(13)||d2
into l_text
from data6
where id = doc_id;
dbms_output.put_line(l_text);
end;
/
begin
test(1);
end;
/
1 rows affected
dbms_output:
Test19.07.31
foobar