Recent content by moguzalp

interestingly with DESC it works properly: select text from sys.all_source where owner = 'MY_SCHEMA' and name = 'PCK_REPORT' and type = 'PACKAGE BODY' and origin_con_id in (1, sys_context('userenv', 'con_id')) order by line DESC

Edit: Origin question title was "pl sql developer freezes after 6000 rows" but I determined that the issue occurs for another package at 700th rows happened. I can select all rows (more than 6000 rows) with the query below. select text from sys.all_source where owner =...

I can not edit spec&body a package that includes report more than 6000 rows. After some search, I found I can do: "C:\Program Files (x86)\PLSQL Developer 13\plsqldev.exe" DebugSQL then retry editing package, I have debut.txt in path given below: C:\Users\AppData\Roaming\PLSQL Developer 13...