[Satish Kamatkar]

I have tried all of the following and they don’t seem to work:

1)
begin
stored_proc_name(‘param1′,’param2’);
end;

2)
stored_proc_name(‘param1′,’param2’);

3)
begin
exec stored_proc_name(‘param1′,’param2’);
end;

4) exec stored_proc_name(‘param1′,’param2’);

What is the right syntax to do this?

Thanks, Satish

[Riyad Kalla]

I am looking into this.

[Riyad Kalla]

One of our developers said this:

He seems to be just trying to do this in the vanilla SQLEditor, not in
any of the Oracle specific extensions. I do not know Oracle syntax for
executing a stored proc, so cannot comment on that. However, there
should be an “Execute” action from the DB browser context menu for
Procedure nodes.

[Satish Kamatkar]

I do not know what you mean by “vaniall sqleditor” ? I tried the developer’s suggestion and that does not work either. In the DB Browser if I right click on the Procedure that I want to execute, all I see is “Copy Name” context menu.

What else can I try? Looking for suggestions.

Thanks, Satish

[support-michael]

1) from SQL editor use “CALL” to directly invoke procedure

2) if you are using MyEclipse 4.0M2 you can select a procedure/function and execute it directly. Doing this will open a small dialog into which you enter the parameters. The results are displayed in the dialog on return.

[Satish Kamatkar]

Yup, this did work…call stored_proc_name(param1,param2);

I am using 3.8.4 for Eclipse 3.0.2

Thanks, Satish

[Author]

Posts