SQL Developer 17.4 hangs when opening a wrapped SQL file

Ryan B Jan 24, 2018 11:41 PM

Hi Everyone,

For some reason I can not get SQL Developer to open a SQL file that contains wrapped code.

I usually load the wrapped version of my package into my Dev environment for one final test before release. In this new version SQL Developer seems to choke when opening the wrapped file. The windows stop refreshing and the file only partially opens. It is no longer usable at this point. If I close the SQL file, everything returns to normal. I tried looking at another wrapped package and ran into the same issue. I am not looking to unwrap my code, only load the wrapped version into my database.

Has anyone encountered this?

Thanks.

Ryan

1. Re: SQL Developer 17.4 hangs when opening a wrapped SQL file

Pierre Yotti Jan 24, 2018 11:23 PM (in response to Ryan B)

https://www.salvis.com/blog/plsql-unwrapper-for-sql-developer/
Like Show 1 Likes(1)

Actions
2. Re: SQL Developer 17.4 hangs when opening a wrapped SQL file

Gary Graham-Oracle Jan 25, 2018 1:30 AM (in response to Ryan B)

This was reported almost as soon as 17.4 got posted on OTN: SQL Developer 17.4.0: Cannot display wrapped code. Bug?

The fix will be available in the next quarterly update, 18.1.
Like Show 0 Likes(0)

Actions
3. Re: SQL Developer 17.4 hangs when opening a wrapped SQL file

Ryan B Jan 25, 2018 2:41 AM (in response to Gary Graham-Oracle)

Thanks for the response, Gary. This is what i was looking for.
Like Show 0 Likes(0)

Actions

Go to original post