I spotted Atul's e-mail on Feb 20,2001 complaining '-9405' error: 'I got problem in declaring nos variable in stored procedure i,e i am getting error -9405
[SAP AG][SQLOD32SLL][live catch]General error;-9405 pos[1] Syntax error:AK Datapart too short. i think that error is due to too many variable declared and its length in stored procedure.' And Thomas replied: '>Q1)How many variable can we declare in stored procedure max 1020 variables. >Q2)What is total maximum length of all variables declared in stored procedure? the sum of all variables length must not be greater than the maximal row size in a table.' Since my stored procedure access multiple tables, does 'maximal row size in a table' means the maximum row size of all the tables, or the sum of the row size of the tables? I checked my stored procedure, and the variable length is about 3060, which is much bigger than my table row size. Is this the reason which cause -9405 error? Thanks, Jenny _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
