A method of and system for collecting an electronic signature for an
electronic record stored in a database. In one embodiment the method
comprises automatically creating an electronic record from data stored in
a plurality of different database tables in response to the occurrence of
a predetermined event; storing an instance of the electronic record in a
common repository of electronic records that provides an audit trail that
cannot be altered or disabled by users of the system; executing a rule
associated with the electronic record to determine whether an electronic
signature is required to connote review and/or approval of the electronic
record; and if execution of the rule results in a determination that an
electronic signature is required, marking the instance of the electronic
record as unsigned and initiating a request to collect the required
electronic signature. In some embodiments the electronic record is stored
as unstructured data in a character large object (CLOB) format and the
unstructured data comprises a well-formed XML document stored within a
column of a table stored in the database.