Print Thread
plsqldoc gets wrong varchar2 size in unicode
#66804 05/19/25 03:57 PM
Joined: Sep 2000
Posts: 16
Milano, Italy
M
mclot Offline OP
Member
OP Offline
Member
M
Joined: Sep 2000
Posts: 16
Milano, Italy
Good morning,
I've got a problem using plsqldoc for the first time: it retrieves the wrong size of the varchar2 fields in an Oracle 19 unicode db.
All other features of PL/SQL Developer are working well but plsqldoc and this makes plsqldoc unusable as documentation tool (at least for me).
Am I wrong something or is this a real bug? It seems it's reading the wrong field in the Oracle dictionary.

I've attached a screenshot showing the difference between plsqldoc and describe command ouputs in PL/SQL Developer.

Best regards
Massimo

Attached Files
plsqldoc unicode varchar2 wrong size.png (106.2 KB, 20 downloads)
plsqldoc unicode varchar2 wrong size: plsqldoc vs describe
Re: plsqldoc gets wrong varchar2 size in unicode
mclot #66806 05/20/25 08:38 AM
Joined: Aug 1999
Posts: 22,663
Member
Offline
Member
Joined: Aug 1999
Posts: 22,663
We'll investigate!


Marco Kalter
Allround Automations

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.159s Queries: 15 (0.095s) Memory: 2.4984 MB (Peak: 3.0397 MB) Data Comp: Off Server Time: 2025-06-14 14:37:21 UTC
Valid HTML 5 and Valid CSS