Calling stored procedures / functions in Oracle using Toad

[DinoVaught]

Does anyone know if there is way to call stored procedures / functions in Oracle using Toad to call the procs / functions?

[Krzemo]

It is very simple...

Select stored proc/function and press yellow "thunder" button (above the tree). Than the form will be shown that gives U oportunity to enter parameters and see the "execute script". And finally U can execute procedure.

Best regards,
Krzemo.

[DinoVaught]

Thanks for the reply. That worked. I got a window titled <Set Parameters> where I could set values for parameters passed into the stored procedure / function / enabled the (Output OUT args) can the <Code Pain> generated what I assume is the same PL/SQL block that the client app’s would run. I was able to copy the SQL from the <Code> pane into Toad’s SQL editor and see it run. Great!

[zubairh]

Hi,

I was reading this query. I did what you said. I executed the stored proc. It produced some pl/sql code which I then pasted into sql window and ran it, but no result sets come.

Is there something I'm doing wrong. i'm new to oracle. I have used sql server which seems so much easier to use! Any help gratly appreciated

[metheglen]

Hi -

I've just moved to a company with a legacy database and a chunk of stored procedures. I too am not getting an execution window within Toad when clicking on the thunder icon.

What I do get is an SQL editor... weird.

Is there some weird compile thing or some user rights that are needed to be able to execute stored procedures within toad?

Cheers for your help

Meths

[Krzemo]

I too am not getting an execution window within Toad when clicking on the thunder icon.

Which version of Toad ?

[zubairh]

I'm using toad version 7.3

[Krzemo]

And I'm using v. 7.5.0.2.
See attachment...