|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
September 22nd, 2004, 04:55 PM
|
||||
|
||||
|
Where are located the packages ?
I want to take a look at source code for procedures but what they
are in packages and show nothing If i do : select DBMS_METADATA.GET_DDL('PROCEDURE',u.object_name) from user_objects u where object_type = 'PROCEDURE' ps: i'm using squirrel-sql with oracle plugin for taking a look at them
|
|
#3
September 22nd, 2004, 05:21 PM
|
|||
|
|||
|
The view ALL_OBJECTS will list any package.
The view ALL_SOURCE has the code for any of the packages. Note: PL/SQL can be compiled in such a way that you cannot get readable code from ALL_SOURCE. It's a twek Oracle came up with to protect their own stuff from prying eyes and your code if you want to. DBMS_OUTPUT source has this 'feature' for example.
|
|
#4
September 23rd, 2004, 05:00 AM
|
||||
|
||||
|
Quote:
Thank you very much  now it works wit ALL_SOURCE also i found TOra http://www.globecom.net/tora/ and now i see some source code for PL/sql
|
|
| Viewing: Dev Shed Forums > Databases > Oracle Development > Where are located the packages ? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
