Try OpenEdge Now
SQL Development
Stored Procedures and Triggers
:
Writing stored procedures
:
Using the OpenEdge SQL Java classes
:
Executing an SQL statement
Executing an SQL statement
If an SQL statement does not generate a result set, stored procedures can execute the statement in one of two ways:
Immediate execution
— Using methods of the
SQLIStatement
class, the procedure executes a statement once.
Prepared execution
— Using methods of the
SQLPStatement
class, the procedure prepares a statement for multiple executions in a procedure loop.