stored procedures with egate

[ewiz]

Hi,
Is it possible to execute stored procedures in my orace database using egate and jdbc. I am new to egate. please suggest how it is possible.

Thanks.

 

[JoelF]

When you build your etd, use the db wizard. Once you've logged in, it will prompt you for the type of database object that you want to use. "Procedure" is one of the options. Pick it, then you are on your way.

Joel.

 

[ramkisb]

When you create ETD using DBWizard, you will get "execute" method in the tree. As JoelF suggested, you can select "procedures" in options. Call "execute" method in collaboration rule to execute procedure after passing data to parameters.