5 replies
A lot of time and effort gets put into the Oracle DBA certification process. Where's Your Oracle DBA?
Going forward - I would recommend either TOAD
or sqlManager - see http://www.toadsoft.com/downld.html for Toad and
http://sqlmanager.net/en/news/607 for sqlManager.
Typically if you have the dba account name as password and schema name, you can load up the schema, and view the source code on your oracle db.
Let me know if:
1. this makes no sense to you at all.
2. it falls beyond yer ken.
hth - mondo regards [Bill]
by babs_1957
Hi Bill -
Thanks for the advice. I did not check the "notify" box so I just happened to see this almost a year later. The truth is that our DBA was the one asking the question. I don't know if she is certified or not. Apparently not since she did have to ask. I'll pass this on just the same for future reference. Even thought I am no longer in that department.
Muchas gracias...Helene
by marv732
Helene,
FYI - if the (PL/SQL) package code was written by Oracle it is probably "wrapped" - a one way encryption of the code to prevent it being pinched. This is done by the wrap binary provided by Oracle in the server software distribution.
Any developer would also have access to this utility as well.
HTH
Greg
by softdream
http://www.softdream.com.cn/Products/SoftDreamOracleUnWrapper/tabid/90/Default.aspx
SoftDream Oracle UnWrapper is a unwrapping software for Oracle 7/8i/9i,Oracle 10g,SQL Server 2005 and Oracle 11 with unwrapping package,package body,stored procedures, triggers, views and user-defined functions,type.If you wrapped your own source code (pl/sql script) of Package,Package Body,Stored Procedure, View, Trigger or Function with "WITH Oracle Wrap Tools",but you neglectful lost it,the application can help you recovery and unwrapping it.
SoftDream Oracle UnWrapper is a "Shareware" program.Before you register it,the appliction only can recover 1200 Bytes. After registeration,the appliction will have no any limit with functionally.
by softdream
http://www.softdream.com.cn/Products/SoftDreamOracleUnWrapper/tabid/90/Default.aspx
SoftDream Oracle UnWrapper is a unwrapping software for Oracle 7/8i/9i,Oracle 10g,SQL Server 2005 and Oracle 11 with unwrapping package,package body,stored procedures, triggers, views and user-defined functions,type.If you wrapped your own source code (pl/sql script) of Package,Package Body,Stored Procedure, View, Trigger or Function with "WITH Oracle Wrap Tools",but you neglectful lost it,the application can help you recovery and unwrapping it.
SoftDream Oracle UnWrapper is a "Shareware" program.Before you register it,the appliction only can recover 1200 Bytes. After registeration,the appliction will have no any limit with functionally.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending