Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Moving a stored procedure

Re: Moving a stored procedure

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Wed, 13 Aug 2003 09:53:24 -0700
Message-ID: <3F3A6D03.190766A4@exxesolutions.com>


"tichi404_at_yahoo.com" wrote:

> I am covering for our DBA who is on vacation - sorry if question seems
> dumb. I remember that
>
> SELECT *
> FROM sys.dba_source
> WHERE type = 'PROCEDURE'
>
> lists all the stored procedures in a database. But somone once showed
> me simple command to move stored procedure from a test database to
> production database (8i) inside sqlplus - I just can't remmber. Can
> anyone help?
>
> -- Ti

Better have that memory checked. There is no easy way. In fact there is no way at all.

You must extract the source code and recreate the procedure.

SELECT text
FROM dba_source
WHERE procedure = '<proc_name>'
ORDER BY line;

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Aug 13 2003 - 11:53:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US