PLSQL procedure

how to acess procedure body in oracle....
or how can i see the PLSQL procidure stored in oracle database

Comments

  • : how to acess procedure body in oracle....
    : or how can i see the PLSQL procidure stored in oracle database

    You can find a program that lets you edit such things. We use SQLNavigator, but it is not a free tool. You can also query the user_text table.


    [size=5][italic][blue][RED]i[/RED]nfidel[/blue][/italic][/size]

    [code]
    $ select * from users where clue > 0
    no rows returned
    [/code]

  • : how to acess procedure body in oracle....
    : or how can i see the PLSQL procidure stored in oracle database
    :




    select text fromm all_source where type='procedure' and name= order by line
  • [b][red]This message was edited by samyms at 2006-2-28 2:40:11[/red][/b][hr]
    select text from user_source where name='procedurename';


Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories