In my case, the error is generated when executing the stored procedure. It must be something else.
Thanks, Jenny On Thu, 2002-09-26 at 02:46, Anhaus, Thomas wrote: > 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 > -- Jenny Zhang Open Source Development Lab Inc 15275 SW Koll Parkway - Suite H Beaverton, OR 97006 (503)626-2455 ext 31 _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
