Jenny Zhang wrote : >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? In the past the sum of the length of all parameters, variables and constants have been limited by the maximal row size of a table (8096 bytes). This limit has been increased to about 32K bytes. If you reach this limit, -9405 will be returned. This assumes, that -9405 is the result of a create dbproc statement execution. Is that the case ? 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
