Posted on 1998-01-23
Is there any way of calling a (Oracle) stored procedure as part of the UpdateSQL queries? For example, I would like to call a stored proc instead of specifing a "Insert" command for the InsertSQL.
After a little work, it looks like it works (it executes and is committed to the database), however I get a "Update Failed' exeception generated from the TUpdateSQL.ExecSQL function. This is because the 'Rows effected' is 0 when returning from a stored proc. Could I subclass the TUpdateSQL class so that I can leave out the "if RowsAffected <> 1" statement?