KB-13968: Executing a StoredProcedure via E3.

Question:

How can I execute an Oracle’s StoredProcedure via E3?

Solution:

In a Query, use the SQL command “call” + StoredProcedure name.

For example:

– E3 Query:

call HourmeterIncrement(‘I724EMD1111’,1)

– Oracle:

exec HourmeterIncrement(‘I724EMD1111’,1);