General information
Title:
Oracle PL/SQL procedure
I am working with Viual FoxPro as a frontend Oracle7 Workgroup Server on NT4 as a backend.
I an creating a trigger (in Oracle) which will compare new value with old value for each field in the table and then record them in the log table if they differ. Here is my problems:
1. I couldn't find a function to load all fields information into the
array in PL/SQL (like AFIELDS() in VFP) so I could scan through
that array and compare old and new field values.
2. The syntax for new & old values in PL/SQL is - new.Employer_Name and
old:Employer_Name where Employer_Name is name of the field.
How I could compare values for each field without hardcoding field name, like:
var1 := 'Employer_Name';
and then use var1 in :old and :new constructions.
Thanks in advance.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only