Alexander Schulz wrote : >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. The call statement is treated as sql statement, i.e. you must provide parameters for the call. Try CALL read_komp_ids_rec (:komponente_child, :serialID, :rec_level); >Please can somebody tell me what the problem may be. >Are recursions in procedures allowed? yes, they are >If not, is there a possible work around? see above >The error message says something about a constant. How to define constants in procedures? constants are not possible yet. The error message unfortunately is a little bit misleading. Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
