Information générale
Titre:
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement