OraFAQ Forum: SQL & PL/SQL » Is it possible to view stored procedures/ Functions that i had created in the next futher login sess

Home » SQL & PL/SQL » SQL & PL/SQL » Is it possible to view stored procedures/ Functions that i had created in the next futher login sess

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Is it possible to view stored procedures/ Functions that i had created in the next futher login sess [message #1007]

Wed, 20 March 2002 18:53

Muralidharan
Messages: 5
Registered: March 2002

Junior Member

hi,

Is it possible to view stored procedures/ Functions that i had created in the next futher login session ?

i tried with this

select Text
from USER_SOURCE
where name='Procname'
and type='procedure'
order by line;

Result : no rows selected.

but its having some set of instructions.

can u help me ? (Hi Tripathy)

Murali

Report message to a moderator

Re: Is it possible to view stored procedures/ Functions that i had created in the next futher login [message #1008 is a reply to message #1007]

Wed, 20 March 2002 20:55

THA
Messages: 26
Registered: February 2002

Junior Member

hello
Use upper case. e.g. 'PROScEDURE' and not 'procedure'
that is the query would be :

select Text
from USER_SOURCE
where name='Procname'
and type='PROCEDURE'
order by line;

thanks

Report message to a moderator

Previous Topic:	Locking when update record
Next Topic:	Execution of two or more queries at a same time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 03:29:43 CDT 2024