| stored procedure's name [message #4415] |
Thu, 05 December 2002 12:47  |
henning kuhn
Messages: 1
Registered: December 2002
|
Junior Member |
|
|
is there any way to determine the stored procedure's
name from within the stored procedure ? (whoami)
(for statistics,e-mails etc)
|
|
|
|
|
|
| Re: stored procedure's name [message #5579 is a reply to message #4415] |
Fri, 21 February 2003 09:03  |
ibbrahim
Messages: 3
Registered: February 2003
|
Junior Member |
|
|
i want to display stored procedure name which i have created in oracle.
for displaing table and view name
i use select table_name from user_table or user_view.
how to see procedure i have created? and how to edit them.
regards
ibbrahim
|
|
|
|
| Re: stored procedure's name [message #5581 is a reply to message #4415] |
Fri, 21 February 2003 09:35 |
Sam Korichi
Messages: 14
Registered: February 2003
|
Junior Member |
|
|
select name,type from user_source
where name='procedure_name';
to view source code
===================
select TEXT from user_source
where name='procedure_name';
to edit it
===========
get the source code
append it to : CREATE OR REPLACE procedure procedure_name
AS
<APPEND here the source code obtained by the above SELECT satement>
You can either use tools as TOAD or SQL WORSHEET to edit source codes of procedures, functions and packages in a manner of graphical interface.
God luck
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
