Jean-Michel OLTRA wrote : > bonjour, > > >Le vendredi 07 octobre 2005, Anhaus, Thomas a écrit... > > >> objects have no knowledge about the db-procedures using it. >> This means that today you have to recreate the db-procedures by hand >> whenever a change of an object accessed inside >> the procedure requires it. > >What does "requires" exactly means ? The dropped table had been >recreated with the .command file of a DATAEXTRACT. I would say that old >(the dropped) and new (the recreated) are identical objects. No ? > >-- >jm > > > >-- >MaxDB Discussion Mailing List >For list archives: http://lists.mysql.com/maxdb >To unsubscribe: >http://lists.mysql.com/maxdb?>[EMAIL PROTECTED] > >
I agree, if the old and new table definition do not differ, it shouldn't be necessary to recompile the db-procedure. Recompilation is necessary for example, if the data type of a column is changed. But you mentioned a problem with NEXTVAL. Is it possible, that a sequence that has been recreated is used inside your procedure ? If this is true and the sequence is accessed directly (i.e. without SQL) this would explain your problems. Best Regards, Thomas -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
