BUG: Fields with embedded NULL (chr(0)) characters not displayed correctly

[Warren Smith]

plsdev seems to truncate output whenever it reaches a NULL character:

SQL> SELECT 'abcd' || chr(0) || 'efg' FROM dual;

'ABCD'||CHR(0)||'EFG'
---------------------
abcd

SQL>

 

[Marco Kalter]

This is indeed a known restriction. varchar2 values are retrieved as zero-terminated strings.