How to get procedure's paramaters

[Walter Wang]

Hi, I want to write a plug in with Delphi and need to process procedures or functions in package. I know "desc [package name].[procedure name]" can show out the result that I need, but I don't know how to get such result it in Delphi. Does anyone can help?

 

[ScottMattes]

If your plugin is meant to work on the package being edited in the editor you should parse that, because if I the user made any changes what I am looking at won't match what is in the DB.

There is a PLSD function to return the contents of the editor, so use that to get the source and then parse through all the lines looking for 'procedure ' or 'function ' as the first characters on the line.

 

[Marco Kalter]

If your Plug-In works on packages in the database, you can execute the following query:

select * from all_arguments a
 where a.owner = <owner>
   and a.object_name = <procedure name>
   and a.package_name = <package name>
 order by a.position

 

[Walter Wang]

Marco Kalter,
Thanks so much!! It's what I need!

ScottMattes
Thanks for your kindly help!