can not see all the information from my field

[stef]

It's not so easy to describe, but I give a try.

I have a table with a field varchar2(2000);
Here I write my stack in case of an error.

Problem is that I cannot get all the information out of the SQL-windows grid. Also in the command window you can not see the complete information:

Info: This is the stack I wrote into the table
--------- ---------- --------- -------------
740-MIC-1-EUROPE\NLDVEN001MIC -2444855-
----- PL/SQL Call Stack -----
object
line object
handle number name
0000000148DBDCA0 25 ARROW.TBI_ARTLOCPROP
000000015E1053D0 111 package body ARROW.SV_SQL
0000000132DA53E0 1 anonymous block
---------------------------------------------
By selecting I get this row, but i cannot see that information: Result
740-MIC-1-EUROPE\NLDVEN001MIC

( the information above, i could see in sqlplus )
but at last not least
Some of the entries I can see.
( Special character ?? )

 

[Marco Kalter]

Could there be a zero character chr(0) in this varchar2 value?

 

[stef]

Actualy not:

I'm building this string:

SELECT sid,vs.OSUSER,vs.MACHINE
into nSid, vcOsUser,vcMachine
FROM V$SESSION VS
WHERE audsid = userenv('sessionid');

recStl.Stl_Stack := to_char(nSid) || '-' || vcOsUser || '-' || vcMachine || '-' || to_charnew.idarticle) || '-' || chr(10) ;
recStl.Stl_Stack := recStl.Stl_Stack || sys.dbms_utility.format_call_stack;

hope this helps?

thx

 

[Marco Kalter]

My guess is that one of these fields includes a chr(0) though. Can you try this?

SELECT replace(sid, chr(0), ''),
replace(vs.OSUSER, chr(0), ''),
replace(vs.MACHINE, chr(0), '')
into nSid, vcOsUser,vcMachine
FROM V$SESSION VS
WHERE audsid = userenv('sessionid');

 

[stef]

Thank you I will try this and let you now!

thx.

 

[stef]

You was right!!

with the select it was already possible to see the complete string!!
thx again!!
I will change my code.

select replace(stl.stl_stack, chr(0), '') , stl.stl_stack
from sb_triggerlog stl
where stl.Stl_Stack like '%2443862%';

byby