pl sql developer freezes after selecting 6000 rows

[moguzalp]

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

finally I found in that file

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
when I run this query in sql window after I click "fetch last page", it freezes after 6000 rows.

Question is how can I set this limit, where is it in preferences?

 

[BruceUK]

If this is a live requirement to edit, you may want to look at using the (very) basic Sql*Plus command line tool on your oracle client. Format with

 

[BruceUK]

Lost most of my reply

 

[William Robertson]

Just tried and I can edit a 6200 line package using version PL/SQL Developer 12.0.7. (Unfortunately I don't have a newer version at work or a 6000 line package to test at home.) I don't know why you are seeing this issue but I'm pretty sure it isn't related to any preference setting.

 

[moguzalp]

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 = 'MY_SCHEMA'
and name = 'PCK_REPORT'
--and type = 'PACKAGE BODY' --without this line
and origin_con_id in (1, sys_context('userenv', 'con_id'))
order by line
So the issue happens for some reports including type = 'PACKAGE BODY'.

On the other hand, I can reproduce same issue with command window, it prints results until 6000 th row (700 th row for second package).

oracle plsqldeveloper

 

[jhughes]

PSD 13 and 14 have both worked fine editing a 13,000+ line package from an Oracle 12 DB for myself and co-workers.
(I just wish I didn't know that.)

 

[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