OraFAQ Forum: Server Administration » How can I take a source of pakage from oracke

Home » RDBMS Server » Server Administration » How can I take a source of pakage from oracke

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How can I take a source of pakage from oracke [message #57791]

Tue, 08 July 2003 05:32

Karri
Messages: 33
Registered: May 2001

Member

Hi

I have a package and I know that error is in line 14 (errormessage says so). What is format of comman l?
I try everything (ex. l 1 20 package_api.. But I don't remember the right format.

Help me, BR Karri

Report message to a moderator

Re: How can I take a source of pakage from oracke [message #57792 is a reply to message #57791]

Tue, 08 July 2003 05:54

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

select line,text from user_source where name='MYPROCEDURE'

Report message to a moderator

Re: How can I take a source of pakage from oracke [message #57822 is a reply to message #57791]

Wed, 09 July 2003 08:28

Michel Bartov
Messages: 35
Registered: February 2003

Member

SELECT text
from DBA_SOURCE
where type='PACKAGE BODY'
and owner='SYS'
and name='DBMS_STATS'
order
by line;

Also I posted an integrated set of GUI tools to manage, monitor and tune the Oracle database. One of the many functions is to display object information including source of procedures, packages etc for a selected schema. The link is http://www.barsoft.net

Report message to a moderator

Previous Topic:	interesting error
Next Topic:	Rebuild Index fails -933

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 14 21:07:20 CST 2025