I think I am pushing SAPDB to some limit. In my storedprocedure, I call another procedure by using CALL fname(...). All the parameters are INOUT. If number of parameter is <= 210, things are fine. But if the number of parameters is somewhere between 210 and 280, I got message: General error;-8005 POS(75344) Value expression must be parameter name. I double checked my code, I did use parameter, not constant. My guess is there is limitation in SAPDB on the number of parameters when using CALL.
Another message I got which is confusing is: General error;-1104 POS(2048) Too complicated SQL statement (KB-stack overflow). The simplified version of my storedprocedure is: do initialization; query; if $rc=0 fetch; ... if $rc=0 fetch; If I have 10 fetches, things are fine. But if I have more fetches, I got the error 1104. I think it is not that the query is complicated, it is something related to length of the storedprocedure. My _PACKET_SIZE is 128k, and my sql file is 19k. Regards, Jenny _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
