Information générale
Titre:
Fetching into a dynamic record
HI,
Is there a way to declare a dymamic record in PL/SQL. I wolud like to build a framework that would insert data from several (23 different)tables.
I can have the column list with the ALL_TAB_COLUMN table and I would like to create a record based on these columns. This way, with EXECUTE IMMEDIATE, I would be able to only change the source and target table and still using the same insert procedure instead of creating 23 different procedure that does the same thing.
Thank you for your help,
Christian Cote
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