obtaining the PL/SQL code of packages ??

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • george lewycky
    #1

    obtaining the PL/SQL code of packages ??

    Hello,

    I'm trying to find out HOW or WHERE to retrieve the actual PL/SQL code
    of the PACKAGE BODY.

    Currently the only means I know of is TOAD's SCHEMA BROWSER.

    Any ideas or suggestions would be really appreciated

    Thanks

    George Lewycky
    Oracle & Financial Applications (pl/sql sql apps faq links code)
    http://georgenet.net/oracle

    Tags: None
    • Mark D Powell
      #2
      Re: obtaining the PL/SQL code of packages ??

      gelewyc@nyct.co m (george lewycky) wrote in message news:<68aecc05. 0407020849.2448 342d@posting.go ogle.com>...
      Hello,
      >
      I'm trying to find out HOW or WHERE to retrieve the actual PL/SQL code
      of the PACKAGE BODY.
      >
      Currently the only means I know of is TOAD's SCHEMA BROWSER.
      >
      Any ideas or suggestions would be really appreciated
      >
      Thanks
      >
      George Lewycky
      http://georgenet.net/oracle
      Just about everything related to objects created in Oracle is
      available via the dictionary: all_, dba_, and user_source. Only the
      owner or a DBA can see the source for a package body but if you have
      execute privilege on the package you can see the specification source
      via these views as long as the source was not wrapped. If the source
      is wrapped you are pretty much out of luck if you do not have the
      source stored away somewhere.

      HTH -- Mark D Powell --

        Comment

        • Alex Filonov
          #3
          Re: obtaining the PL/SQL code of packages ??

          gelewyc@nyct.co m (george lewycky) wrote in message news:<68aecc05. 0407020849.2448 342d@posting.go ogle.com>...
          Hello,
          >
          I'm trying to find out HOW or WHERE to retrieve the actual PL/SQL code
          of the PACKAGE BODY.
          >
          Currently the only means I know of is TOAD's SCHEMA BROWSER.
          >
          Any ideas or suggestions would be really appreciated
          >
          Thanks
          >
          George Lewycky
          http://georgenet.net/oracle
          Select text
          from all_source
          where owner = '<Package owner>'
          and type = 'PACKAGE BODY'
          and name = '<Package name>'

            Comment

            • Chris
              #4
              Re: obtaining the PL/SQL code of packages ??

              afilonov@yahoo. com (Alex Filonov) wrote in message news:<336da121. 0407060832.6aee ad69@posting.go ogle.com>...
              gelewyc@nyct.co m (george lewycky) wrote in message news:<68aecc05. 0407020849.2448 342d@posting.go ogle.com>...
              Hello,

              I'm trying to find out HOW or WHERE to retrieve the actual PL/SQL code
              of the PACKAGE BODY.

              Currently the only means I know of is TOAD's SCHEMA BROWSER.

              Any ideas or suggestions would be really appreciated

              Thanks

              George Lewycky
              http://georgenet.net/oracle
              >
              Select text
              from all_source
              where owner = '<Package owner>'
              and type = 'PACKAGE BODY'
              and name = '<Package name>'

              If you are using Oracle9i, there's also the get_ddl option:

              set pagesize 0
              set long 90000
              SELECT DBMS_METADATA.G ET_DDL('PACKAGE _BODY','PK_SOME NAME') FROM dual;


              set pagesize 0
              set long 90000
              SELECT DBMS_METADATA.G ET_DDL('PACKAGE ','PK_SOMENAME' ) FROM dual;


              you can generate pretty much anything using this.

              chris

                Comment

                • Chris
                  #5
                  Re: obtaining the PL/SQL code of packages ??

                  afilonov@yahoo. com (Alex Filonov) wrote in message news:<336da121. 0407060832.6aee ad69@posting.go ogle.com>...
                  gelewyc@nyct.co m (george lewycky) wrote in message news:<68aecc05. 0407020849.2448 342d@posting.go ogle.com>...
                  Hello,

                  I'm trying to find out HOW or WHERE to retrieve the actual PL/SQL code
                  of the PACKAGE BODY.

                  Currently the only means I know of is TOAD's SCHEMA BROWSER.

                  Any ideas or suggestions would be really appreciated

                  Thanks

                  George Lewycky
                  http://georgenet.net/oracle
                  >
                  Select text
                  from all_source
                  where owner = '<Package owner>'
                  and type = 'PACKAGE BODY'
                  and name = '<Package name>'

                  If you are using Oracle9i, there's also the get_ddl option:

                  set pagesize 0
                  set long 90000
                  SELECT DBMS_METADATA.G ET_DDL('PACKAGE _BODY','PK_SOME NAME') FROM dual;


                  set pagesize 0
                  set long 90000
                  SELECT DBMS_METADATA.G ET_DDL('PACKAGE ','PK_SOMENAME' ) FROM dual;


                  you can generate pretty much anything using this.

                  chris

                    Comment

                    Previous template Next
                    Working...