global variables vs get statements

[Quoted] I need to insert and update the userid and the sysdate into audit columns every time a user creates or changes a record.

Which is more efficient:

1. To create a PRE-FORM trigger with the following code:

[Quoted] :global.username := get_application_property(username);
:global.date := sysdate;

And then reference these variables in PRE-INSERT and PRE-UPDATE triggers at the block
level.

Or.....

2) Simply create PRE-INSERT and PRE-UPDATE triggers with the following code:

:block.audit_username := get_application_property(username);
:block.audit_date := sysdate;

Does doing the GET_ statement and fetching the sysdate over and over again waste resources?

Thanks,

Baman Received on Wed Jun 23 1999 - 15:06:39 CEST