Found it, is was USER_SOURCE

thanks anyway.

Karl O'Sullivan
Senior Analyst Programmer
University Hospitals Coventry and Warwickshire NHS Trust
Tel: 024 7660 2020 x7578

        ----------
        From:   p=NHS NATIONAL 
INT;a=NHS;c=GB;dda:RFC-822=matt.horn(a)mediatelgroup.co.uk;
        Sent:   13 August 2002 11:55
        To:     p=NHS NATIONAL 
INT;a=NHS;c=GB;dda:RFC-822=dev(a)lists.cfdeveloper.co.uk;
        Subject:        Re: [ cf-dev ] OT: Oracle viewing procedures

        sysobjects?

        or sysobjs?

        something like that I  think

        Matt


        At 09:33 13/08/02 +0100, you wrote:
        >Hi Guys,
        >
        >Can anyone remember which table Oracle stores procedures/functions in?
        >
        >I've got to edit a procedure that is stored on the server, but I don't 
        >have the source.  I know it was obviously created with CREATE PROCEDURE... 
        >but can't remember which table/view these are stored in.
        >
        >Thanks
        >
        >Karl.
        >
        >
        >Karl O'Sullivan
        >Senior Analyst Programmer
        >University Hospitals Coventry and Warwickshire NHS Trust
        >Tel: 024 7660 2020 x7578
        >
        >--
        >To unsubscribe, e-mail: [EMAIL PROTECTED]
        >For additional commands, e-mail: [EMAIL PROTECTED]
        >For human help, e-mail: [EMAIL PROTECTED]


        -- 
        To unsubscribe, e-mail: [EMAIL PROTECTED]
        For additional commands, e-mail: [EMAIL PROTECTED]
        For human help, e-mail: [EMAIL PROTECTED]




-- 
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
For human help, e-mail: [EMAIL PROTECTED]


Reply via email to