viewing PL/SQL code
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: viewing PL/SQL code

  1. #1
    Join Date
    Jan 2002
    Posts
    40

    Question

    Hello everybody,

    I'am working in an private firm for supporting their oracle s/w and I need some urgent help...............

    I'am trying to view PL/SQL code using the query
    'select substr(text,1,200) from user_source where name =&name and type='PACKAGE';
    .....The query is running but the problem is that its giving some ASCII code ...
    the starting line of the code gives
    ..... Package is wrapped
    ------rest all are ascii characters

    is there any way in which I could view the original code...

    Thanking you all.

    SFDBA

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    No other ways, that was made to protect code.
    Best wishes!
    Dmitri

  3. #3
    Join Date
    Apr 2001
    Posts
    107
    Hi,

    Maybe you could use Toad from quest software?
    The download of a trial version is free...

    Hope it helps

    Cheers

    Fabien

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width