Invoking Oracle function [using WmDB package]


In built-in service reference guide it is said that pub.db:call is used to execute stored procedures. Is there anyway using which I can invoke an Oracle function. If so, what is the syntax, and required mappings?

Once it is executed, it returns $dbMessage as the success or error flag.

How do I get the actual data out if this oracle function is to return out something.

Any help in this regard is much appreciated… Thanks in advance. :slight_smile:


As noted here on wMUsers many times before, you should not use the WmDB adapter. Instead use the JDBC Adapter and its stored procedure or stored procedure with signature templates to invoke an Oracle function.


Thanks Mark, but our client wants us to use only wmDB adapter. So, is there any other work around ?