Howdy, Stranger!

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

Categories

PLSQL procedure

39inam39inam Member Posts: 69
how to acess procedure body in oracle....
or how can i see the PLSQL procidure stored in oracle database

Comments

  • infidelinfidel Member Posts: 2,900
    : 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]

  • chris_marieachris_mariea Member Posts: 1
    : 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
  • samymssamyms Member Posts: 5
    [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.