new line sign [message #161020] |
Wed, 01 March 2006 07:58  |
fabi
Messages: 26 Registered: February 2006
|
Junior Member |
|
|
hi. how can i use new line sign (\n) in dbms_output.putline???
dbms('Hi my name is lukas'). i want lukas in new line.
thanks
|
|
|
Re: new line sign [message #161023 is a reply to message #161020] |
Wed, 01 March 2006 08:01   |
Art Metzer
Messages: 2480 Registered: December 2002
|
Senior Member |
|
|
SQL> SET SERVEROUTPUT ON
SQL> EXEC DBMS_OUTPUT.PUT_LINE('Hi my name is ' || CHR(13) || CHR(10) || 'lukas.');
Hi my name is
lukas.
PL/SQL procedure successfully completed.
SQL>
|
|
|
|
|
|
Re: new line sign [message #421326 is a reply to message #161029] |
Mon, 07 September 2009 09:12   |
suman.g
Messages: 89 Registered: June 2009
|
Member |
|
|
Hi All,
I am able to insert new line character in DBMS_OUTPUT.PUT_LINE but same is not working when concatenating procedure variables.
My code is like :
*some code
for rec2 in get_seg2(v_value,v_org)
loop
v_conc_segs2:=v_conc_segs2||CHR(13)||CHR(10)||rec2.cs;
EXIT WHEN get_seg2%NOTFOUND;
end loop;
v_conc_segs:=v_conc_segs2;
end if;
dbms_output.put_line(v_conc_segs);
*some code
I am getting the error below:
ORA-20000: ORU-10028: line length overflow, limit of 255 chars per line
Please suggest something!!
Thanks in advance..
Regards,
Suman
|
|
|
Re: new line sign [message #421328 is a reply to message #421326] |
Mon, 07 September 2009 09:18   |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
In older versions of Oracle dbms_output.put_line can not output more than 255 characters.
|
|
|
|
Re: new line sign [message #421331 is a reply to message #421329] |
Mon, 07 September 2009 09:28   |
suman.g
Messages: 89 Registered: June 2009
|
Member |
|
|
Thanks sir..
But I am using this code in formula column of rdf report so not possible to retun more than one row at a time but my query is fetching 311 rows.
Is there any way to handle this..
Regards,
Suman
|
|
|
|
Re: new line sign [message #421336 is a reply to message #421332] |
Mon, 07 September 2009 09:53   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Quote: | remove the calls to dbms_output - the report has no use for them.
|
Unless you're doing something really stupid and reading back using DBMS_OUTPUT.GET...
You're not doing that, are you?
|
|
|
|
|
|
|