|
How to setup TOCIQuery to use stored proc for posting updates ? |
|
|
|
|
Sep 19, 2006 |
|
See ProcUpd demo. It implements such technique. In general you should use TOCIQuery linked with TOCIUpdateSQL. TOCIUpdateSQL have properties SQLUpdate, SQLInsert, etc. To some of them you should assign PL/SQL anonymous block, that will call stored procedure. To transmit old field values use parameters with prefix OLD_, for new field values - use field names as parameter names or prefix it with NEW_.
|
