DBExplorer - How to run functions/procedures? Anonymous - Apr 29, 2005 - 12:07 PM Post subject: How to run functions/procedures?
Anyone know the syntax to run functions/procedures? They work fine in Oracle SQL*Plus, but I cannot run similar commands in the SQL Run window.
Anonymous - Dec 13, 2005 - 05:02 PM Post subject: RE: How to run functions/procedures?
I'm having the same problem. I can "execute sp_my_procedure('something');" from SQL*Plus, but I can't from within Eclipse. A work around is to right-click on the stored procedure name in the tree and click run from the menu. A prompt is provided to supply stored procedure parameters. With that said, I need to be able to run via the SQL Editor window.