Hi, I'm trying to write a recursive database procedure with a 7.3 Database.
Procedure declaration: CREATE DBPROC read_komp_ids_rec (IN parentID FIXED(20,0), IN serialID FIXED(20,0), IN rec_level FIXED(20,0)) AS VAR komponente_child fixed(20,0); ... In this procedure I call: CALL read_komp_ids_rec (komponente_child, serialID, rec_level); In SQL Studio error dialog the first parameter is marked and I get the following error Message: Error in assignment;-8004 POS(2179) Constant must be compatible with column type and length. Please can somebody tell me what the problem may be. Are recursions in procedures allowed? If not, is there a possible work around? The error message says something about a constant. How to define constants in procedures? Thanks in advance. MfG Alexander Schulz _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
