Print Thread
PL/SQL Developer 14.0 + PLJSON library
#62756 11/15/21 06:51 AM
Joined: Nov 2021
Posts: 5
I
ITTCT Offline OP
Member
OP Offline
Member
I
Joined: Nov 2021
Posts: 5
Hi,

I am using PL/SQL Developer 14.0.6 and PL/JSON package for parsing json and Oracle 11g.
My experience is when I try to use the autocomplete feature in the developer related to the pljson functions the application crashes.
Did someone else experience this problem? What could be a solution?
There are no logs about this, only windows log has an entry, I'll attach it.

Thanks,
ITTCT

Attached Files
plsql14.zip (1.5 KB, 3 downloads)
SHA1: dc77dc8c399b5fecd898eb090ca0944d66037949
Re: PL/SQL Developer 14.0 + PLJSON library
ITTCT #62757 11/15/21 09:46 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
To obtain some more diagnostic information, can you modify the PL/SQL Developer shortcut and add the DebugSQL parameter? For example:

"C:\Program Files\PLSQL Developer 14\plsqldev.exe" DebugSQL

Reproduce the problem and send me the debug.txt file that is generated in the %APPDATA%\PLSQL Developer 14 directory (e.g. C:\Users\<User>\AppData\Roaming\PLSQL Developer 14).


Marco Kalter
Allround Automations
Re: PL/SQL Developer 14.0 + PLJSON library
Marco Kalter #62758 11/15/21 09:58 AM
Joined: Nov 2021
Posts: 5
I
ITTCT Offline OP
Member
OP Offline
Member
I
Joined: Nov 2021
Posts: 5
Thanks, I attached the Debug.txt.

Attached Files
Debug.txt (39.59 KB, 3 downloads)
SHA1: 5a48406d29a052cfb8f6b4cdfa9e3f7e03f49792
Re: PL/SQL Developer 14.0 + PLJSON library
ITTCT #62759 11/16/21 10:28 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
Thanks. I see that you are using a very old Oracle Client version (9.2). Can you update to a more recent client version and try again?


Marco Kalter
Allround Automations
Re: PL/SQL Developer 14.0 + PLJSON library
Marco Kalter #62762 11/18/21 07:17 AM
Joined: Nov 2021
Posts: 5
I
ITTCT Offline OP
Member
OP Offline
Member
I
Joined: Nov 2021
Posts: 5
Thanks a lot, installing 11.2 client solved this problem. Due to our system's limitation I can't use newer versions.

Regards,
ITTCT


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.052s Queries: 16 (0.032s) Memory: 2.5167 MB (Peak: 3.0427 MB) Data Comp: Off Server Time: 2024-05-18 13:54:55 UTC
Valid HTML 5 and Valid CSS