Re: how can I list procedure source

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: 2000/07/23
Message-ID: <397AB4F8.62AA63EE@0800-einwahl.de>#1/1

Use this script:

• get_src.sql gets all sources from the current schema.
• Martin Haltmayer, 02/05/2000
• Last change:
• 2000/07/19: MH: Set arraysize to avoid buffer overflow.

set arraysize 1
set echo off
set feedback off
set linesize 1000
set pagesize 0
set termout off
set timing off
set trimspool on
set verify off

spool get_src.wrk

column name noprint
column type noprint
column line noprint

select

	s.name


	, s.type

	, 0 as line

	, 'create or replace' as txt

from
	user_source s

where 1 = 1
and 1 = s.line

--
union all
--
select
	s.name


	, s.type

	, 9999999999999997 as line

	, '/'

from
	user_source s
where 1 = 1
and 1 = s.line
--
union all
--
select
	s.name


	, s.type

	, s.line

	, s.text

from
	user_source s
--
union all
--
select
	s.name


	, s.type

	, 9999999999999998 as line

	, 'show errors' as txt

from
	user_source s
where 1 = 1
and 1 = s.line
--
union all
--
select
	s.name


	, s.type

	, 9999999999999999 as line

	, null as txt

from
	user_source s
where 1 = 1
and 1 = s.line
--
order by 1, 2, 3
/

spool off

-- exit

Start it with "sqlplus usr/pass_at_conn @ get_src.sql < nul" on NT or "sqlplus
usr/pass_at_conn @ get_src.sql < /dev/null" on Unix. Creates scripts to reproduce
your source. Does not work for wrapped functions, of course.

Martin



John Dunn wrote:
> 
> how can i get  the source of a pl/sql procedure or function, from sqlplus?
> 
> John

Received on Sun Jul 23 2000 - 00:00:00 CDT