Re: Moving a stored procedure

"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)