SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Executing a package in SQL Developer

faraz-dbaJan 19 2015 — edited Jan 19 2015

Hi,

when I have to introduce a new package into a database and the package is given bz a *.pkg file, what is the difference between opening the package file in SQL Developer (through "Open"-->"File") and then execute the package and just copy pasting the Pl/SQL code out of the package into an editor.

I am asking cause I have made the following experience, which I have posted here:

Faraz' Oracle DBA Blog: Mistake of opening an PL/SQL package as file in Oracle SQL Developer

This post has been answered by thatJeffSmith-Oracle on Jan 19 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 16 2015

Added on Jan 19 2015

#plsql, #sql, #sql-developer

2 comments

4,462 views