the following is taken from knldiag. I called the storedprocedure twice
=====
2002-03-12 17:44:40 15938 11007 COMMUNIC wait for connection T29
2002-03-12 17:47:12 15938 11561 COMMUNIC Connected T29
localhost.localdomain 17260
2002-03-12 17:47:12 15938 ERR 54111 MOVE VAK262.11: 1[126704]->8443[8192]
len:7
2002-03-12 17:47:12 15938 ERR 51080 SYSERROR -9111 Move error
2002-03-12 17:47:20 15929 WNG 11840 COMMUNIC Killing T29 for died apid 17260
2002-03-12 17:47:20 15938 WNG 11804 COMMUNIC application dead for T29
2002-03-12 17:47:20 15938 WNG 11824 COMMUNIC Releasing T29 connection aborted
2002-03-12 17:47:20 15938 11007 COMMUNIC wait for connection T29
2002-03-12 17:51:36 15938 11561 COMMUNIC Connected T29
localhost.localdomain 17266
2002-03-12 17:51:36 15938 ERR 54111 MOVE VAK262.11: 1[126704]->8443[8192]
len:7
2002-03-12 17:51:36 15938 ERR 51080 SYSERROR -9111 Move error
======
I am using sapdb 7.3.0.21 on redhat 7.2. The attached are my storedprocedure
files.
Thanks,
Jenny
On Monday 11 March 2002 10:22 pm, you wrote:
> Hi Jenny,
> this is an error that should never happen. It tells us, that
> a memcpy is trying to leave the expected range, i.e. it's
> a system error due to a bug we have made.
> However, I need more information to find out, what's going wrong and
> if there is a chance to avoid the problem.
> If possible, please send me the following information :
> 1. the source code of the stored procedure.
> 2. the content of knldiag, after the error occurred.
> 3. the build number of the SAPDB kernel you are using.
>
> thanks in advance
> Thomas
>
> ---
>
> Thomas Anhaus
> SAPDB, SAP Labs Berlin
>
>
> -----Original Message-----
> From: Jenny Zhang [mailto:[EMAIL PROTECTED]]
> Sent: Montag, 11. M�rz 2002 18:47
> To: [EMAIL PROTECTED]
> Subject: 9111 error
>
>
> I got this 9111 error when executing my storedprocedure, I can not find it
> in the message manul. What does it mean? Any recommendation how to
> avoid this?
>
> [1] sqlstate S1000 : [SAP AG][LIBSQLOD SO][SAP DB]General error;-9111
> POS(1)
>
> System error: Move error.
>
> Thanks,
> Jenny
> _______________________________________________
> sapdb.general mailing list
> [EMAIL PROTECTED]
> http://listserv.sap.com/mailman/listinfo/sapdb.general
DROP DBPROC initOrderItems;
/* Clause 2.9.3 */
CREATE DBPROC initOrderItems(
INOUT i_id1 FIXED(10), INOUT i_title1 VARCHAR(60),
INOUT i_publisher1 VARCHAR(60), INOUT i_cost1 FIXED(17, 2),
INOUT ol_qty1 FIXED(3), INOUT ol_discount1 FIXED(17, 2),
INOUT ol_comments1 VARCHAR(100),
INOUT i_id2 FIXED(10), INOUT i_title2 VARCHAR(60),
INOUT i_publisher2 VARCHAR(60), INOUT i_cost2 FIXED(17, 2),
INOUT ol_qty2 FIXED(3), INOUT ol_discount2 FIXED(17, 2),
INOUT ol_comments2 VARCHAR(100),
INOUT i_id3 FIXED(10), INOUT i_title3 VARCHAR(60),
INOUT i_publisher3 VARCHAR(60), INOUT i_cost3 FIXED(17, 2),
INOUT ol_qty3 FIXED(3), INOUT ol_discount3 FIXED(17, 2),
INOUT ol_comments3 VARCHAR(100),
INOUT i_id4 FIXED(10), INOUT i_title4 VARCHAR(60),
INOUT i_publisher4 VARCHAR(60), INOUT i_cost4 FIXED(17, 2),
INOUT ol_qty4 FIXED(3), INOUT ol_discount4 FIXED(17, 2),
INOUT ol_comments4 VARCHAR(100),
INOUT i_id5 FIXED(10), INOUT i_title5 VARCHAR(60),
INOUT i_publisher5 VARCHAR(60), INOUT i_cost5 FIXED(17, 2),
INOUT ol_qty5 FIXED(3), INOUT ol_discount5 FIXED(17, 2),
INOUT ol_comments5 VARCHAR(100),
INOUT i_id6 FIXED(10), INOUT i_title6 VARCHAR(60),
INOUT i_publisher6 VARCHAR(60), INOUT i_cost6 FIXED(17, 2),
INOUT ol_qty6 FIXED(3), INOUT ol_discount6 FIXED(17, 2),
INOUT ol_comments6 VARCHAR(100),
INOUT i_id7 FIXED(10), INOUT i_title7 VARCHAR(60),
INOUT i_publisher7 VARCHAR(60), INOUT i_cost7 FIXED(17, 2),
INOUT ol_qty7 FIXED(3), INOUT ol_discount7 FIXED(17, 2),
INOUT ol_comments7 VARCHAR(100),
INOUT i_id8 FIXED(10), INOUT i_title8 VARCHAR(60),
INOUT i_publisher8 VARCHAR(60), INOUT i_cost8 FIXED(17, 2),
INOUT ol_qty8 FIXED(3), INOUT ol_discount8 FIXED(17, 2),
INOUT ol_comments8 VARCHAR(100),
INOUT i_id9 FIXED(10), INOUT i_title9 VARCHAR(60),
INOUT i_publisher9 VARCHAR(60), INOUT i_cost9 FIXED(17, 2),
INOUT ol_qty9 FIXED(3), INOUT ol_discount9 FIXED(17, 2),
INOUT ol_comments9 VARCHAR(100),
INOUT i_id10 FIXED(10), INOUT i_title10 VARCHAR(60),
INOUT i_publisher10 VARCHAR(60), INOUT i_cost10 FIXED(17, 2),
INOUT ol_qty10 FIXED(3), INOUT ol_discount10 FIXED(17, 2),
INOUT ol_comments10 VARCHAR(100),
INOUT i_id11 FIXED(10), INOUT i_title11 VARCHAR(60),
INOUT i_publisher11 VARCHAR(60), INOUT i_cost11 FIXED(17, 2),
INOUT ol_qty11 FIXED(3), INOUT ol_discount11 FIXED(17, 2),
INOUT ol_comments11 VARCHAR(100),
INOUT i_id12 FIXED(10), INOUT i_title12 VARCHAR(60),
INOUT i_publisher12 VARCHAR(60), INOUT i_cost12 FIXED(17, 2),
INOUT ol_qty12 FIXED(3), INOUT ol_discount12 FIXED(17, 2),
INOUT ol_comments12 VARCHAR(100),
INOUT i_id13 FIXED(10), INOUT i_title13 VARCHAR(60),
INOUT i_publisher13 VARCHAR(60), INOUT i_cost13 FIXED(17, 2),
INOUT ol_qty13 FIXED(3), INOUT ol_discount13 FIXED(17, 2),
INOUT ol_comments13 VARCHAR(100),
INOUT i_id14 FIXED(10), INOUT i_title14 VARCHAR(60),
INOUT i_publisher14 VARCHAR(60), INOUT i_cost14 FIXED(17, 2),
INOUT ol_qty14 FIXED(3), INOUT ol_discount14 FIXED(17, 2),
INOUT ol_comments14 VARCHAR(100),
INOUT i_id15 FIXED(10), INOUT i_title15 VARCHAR(60),
INOUT i_publisher15 VARCHAR(60), INOUT i_cost15 FIXED(17, 2),
INOUT ol_qty15 FIXED(3), INOUT ol_discount15 FIXED(17, 2),
INOUT ol_comments15 VARCHAR(100),
INOUT i_id16 FIXED(10), INOUT i_title16 VARCHAR(60),
INOUT i_publisher16 VARCHAR(60), INOUT i_cost16 FIXED(17, 2),
INOUT ol_qty16 FIXED(3), INOUT ol_discount16 FIXED(17, 2),
INOUT ol_comments16 VARCHAR(100),
INOUT i_id17 FIXED(10), INOUT i_title17 VARCHAR(60),
INOUT i_publisher17 VARCHAR(60), INOUT i_cost17 FIXED(17, 2),
INOUT ol_qty17 FIXED(3), INOUT ol_discount17 FIXED(17, 2),
INOUT ol_comments17 VARCHAR(100),
INOUT i_id18 FIXED(10), INOUT i_title18 VARCHAR(60),
INOUT i_publisher18 VARCHAR(60), INOUT i_cost18 FIXED(17, 2),
INOUT ol_qty18 FIXED(3), INOUT ol_discount18 FIXED(17, 2),
INOUT ol_comments18 VARCHAR(100),
INOUT i_id19 FIXED(10), INOUT i_title19 VARCHAR(60),
INOUT i_publisher19 VARCHAR(60), INOUT i_cost19 FIXED(17, 2),
INOUT ol_qty19 FIXED(3), INOUT ol_discount19 FIXED(17, 2),
INOUT ol_comments19 VARCHAR(100),
INOUT i_id20 FIXED(10), INOUT i_title20 VARCHAR(60),
INOUT i_publisher20 VARCHAR(60), INOUT i_cost20 FIXED(17, 2),
INOUT ol_qty20 FIXED(3), INOUT ol_discount20 FIXED(17, 2),
INOUT ol_comments20 VARCHAR(100),
INOUT i_id21 FIXED(10), INOUT i_title21 VARCHAR(60),
INOUT i_publisher21 VARCHAR(60), INOUT i_cost21 FIXED(17, 2),
INOUT ol_qty21 FIXED(3), INOUT ol_discount21 FIXED(17, 2),
INOUT ol_comments21 VARCHAR(100),
INOUT i_id22 FIXED(10), INOUT i_title22 VARCHAR(60),
INOUT i_publisher22 VARCHAR(60), INOUT i_cost22 FIXED(17, 2),
INOUT ol_qty22 FIXED(3), INOUT ol_discount22 FIXED(17, 2),
INOUT ol_comments22 VARCHAR(100),
INOUT i_id23 FIXED(10), INOUT i_title23 VARCHAR(60),
INOUT i_publisher23 VARCHAR(60), INOUT i_cost23 FIXED(17, 2),
INOUT ol_qty23 FIXED(3), INOUT ol_discount23 FIXED(17, 2),
INOUT ol_comments23 VARCHAR(100),
INOUT i_id24 FIXED(10), INOUT i_title24 VARCHAR(60),
INOUT i_publisher24 VARCHAR(60), INOUT i_cost24 FIXED(17, 2),
INOUT ol_qty24 FIXED(3), INOUT ol_discount24 FIXED(17, 2),
INOUT ol_comments24 VARCHAR(100),
INOUT i_id25 FIXED(10), INOUT i_title25 VARCHAR(60),
INOUT i_publisher25 VARCHAR(60), INOUT i_cost25 FIXED(17, 2),
INOUT ol_qty25 FIXED(3), INOUT ol_discount25 FIXED(17, 2),
INOUT ol_comments25 VARCHAR(100),
INOUT i_id26 FIXED(10), INOUT i_title26 VARCHAR(60),
INOUT i_publisher26 VARCHAR(60), INOUT i_cost26 FIXED(17, 2),
INOUT ol_qty26 FIXED(3), INOUT ol_discount26 FIXED(17, 2),
INOUT ol_comments26 VARCHAR(100),
INOUT i_id27 FIXED(10), INOUT i_title27 VARCHAR(60),
INOUT i_publisher27 VARCHAR(60), INOUT i_cost27 FIXED(17, 2),
INOUT ol_qty27 FIXED(3), INOUT ol_discount27 FIXED(17, 2),
INOUT ol_comments27 VARCHAR(100),
INOUT i_id28 FIXED(10), INOUT i_title28 VARCHAR(60),
INOUT i_publisher28 VARCHAR(60), INOUT i_cost28 FIXED(17, 2),
INOUT ol_qty28 FIXED(3), INOUT ol_discount28 FIXED(17, 2),
INOUT ol_comments28 VARCHAR(100),
INOUT i_id29 FIXED(10), INOUT i_title29 VARCHAR(60),
INOUT i_publisher29 VARCHAR(60), INOUT i_cost29 FIXED(17, 2),
INOUT ol_qty29 FIXED(3), INOUT ol_discount29 FIXED(17, 2),
INOUT ol_comments29 VARCHAR(100),
INOUT i_id30 FIXED(10), INOUT i_title30 VARCHAR(60),
INOUT i_publisher30 VARCHAR(60), INOUT i_cost30 FIXED(17, 2),
INOUT ol_qty30 FIXED(3), INOUT ol_discount30 FIXED(17, 2),
INOUT ol_comments30 VARCHAR(100)) AS
BEGIN
SET i_id1 = 0;
SET i_title1 = '';
SET i_publisher1 = '';
SET i_cost1 = 0;
SET ol_qty1 = 0;
SET ol_discount1 = 0;
SET ol_comments1 = '';
SET i_id2 = 0;
SET i_title2 = '';
SET i_publisher2 = '';
SET i_cost2 = 0;
SET ol_qty2 = 0;
SET ol_discount2 = 0;
SET ol_comments2 = '';
SET i_id3 = 0;
SET i_title3 = '';
SET i_publisher3 = '';
SET i_cost3 = 0;
SET ol_qty3 = 0;
SET ol_discount3 = 0;
SET ol_comments3 = '';
SET i_id4 = 0;
SET i_title4 = '';
SET i_publisher4 = '';
SET i_cost4 = 0;
SET ol_qty4 = 0;
SET ol_discount4 = 0;
SET ol_comments4 = '';
SET i_id5 = 0;
SET i_title5 = '';
SET i_publisher5 = '';
SET i_cost5 = 0;
SET ol_qty5 = 0;
SET ol_discount5 = 0;
SET ol_comments5 = '';
SET i_id6 = 0;
SET i_title6 = '';
SET i_publisher6 = '';
SET i_cost6 = 0;
SET ol_qty6 = 0;
SET ol_discount6 = 0;
SET ol_comments6 = '';
SET i_id7 = 0;
SET i_title7 = '';
SET i_publisher7 = '';
SET i_cost7 = 0;
SET ol_qty7 = 0;
SET ol_discount7 = 0;
SET ol_comments7 = '';
SET i_id8 = 0;
SET i_title8 = '';
SET i_publisher8 = '';
SET i_cost8 = 0;
SET ol_qty8 = 0;
SET ol_discount8 = 0;
SET ol_comments8 = '';
SET i_id9 = 0;
SET i_title9 = '';
SET i_publisher9 = '';
SET i_cost9 = 0;
SET ol_qty9 = 0;
SET ol_discount9 = 0;
SET ol_comments9 = '';
SET i_id10 = 0;
SET i_title10 = '';
SET i_publisher10 = '';
SET i_cost10 = 0;
SET ol_qty10 = 0;
SET ol_discount10 = 0;
SET ol_comments10 = '';
SET i_id11 = 0;
SET i_title11 = '';
SET i_publisher11 = '';
SET i_cost11 = 0;
SET ol_qty11 = 0;
SET ol_discount11 = 0;
SET ol_comments11 = '';
SET i_id12 = 0;
SET i_title12 = '';
SET i_publisher12 = '';
SET i_cost12 = 0;
SET ol_qty12 = 0;
SET ol_discount12 = 0;
SET ol_comments12 = '';
SET i_id13 = 0;
SET i_title13 = '';
SET i_publisher13 = '';
SET i_cost13 = 0;
SET ol_qty13 = 0;
SET ol_discount13 = 0;
SET ol_comments13 = '';
SET i_id14 = 0;
SET i_title14 = '';
SET i_publisher14 = '';
SET i_cost14 = 0;
SET ol_qty14 = 0;
SET ol_discount14 = 0;
SET ol_comments14 = '';
SET i_id15 = 0;
SET i_title15 = '';
SET i_publisher15 = '';
SET i_cost15 = 0;
SET ol_qty15 = 0;
SET ol_discount15 = 0;
SET ol_comments15 = '';
SET i_id16 = 0;
SET i_title16 = '';
SET i_publisher16 = '';
SET i_cost16 = 0;
SET ol_qty16 = 0;
SET ol_discount16 = 0;
SET ol_comments16 = '';
SET i_id17 = 0;
SET i_title17 = '';
SET i_publisher17 = '';
SET i_cost17 = 0;
SET ol_qty17 = 0;
SET ol_discount17 = 0;
SET ol_comments17 = '';
SET i_id18 = 0;
SET i_title18 = '';
SET i_publisher18 = '';
SET i_cost18 = 0;
SET ol_qty18 = 0;
SET ol_discount18 = 0;
SET ol_comments18 = '';
SET i_id19 = 0;
SET i_title19 = '';
SET i_publisher19 = '';
SET i_cost19 = 0;
SET ol_qty19 = 0;
SET ol_discount19 = 0;
SET ol_comments19 = '';
SET i_id20 = 0;
SET i_title20 = '';
SET i_publisher20 = '';
SET i_cost20 = 0;
SET ol_qty20 = 0;
SET ol_discount20 = 0;
SET ol_comments20 = '';
SET i_id21 = 0;
SET i_title21 = '';
SET i_publisher21 = '';
SET i_cost21 = 0;
SET ol_qty21 = 0;
SET ol_discount21 = 0;
SET ol_comments21 = '';
SET i_id22 = 0;
SET i_title22 = '';
SET i_publisher22 = '';
SET i_cost22 = 0;
SET ol_qty22 = 0;
SET ol_discount22 = 0;
SET ol_comments22 = '';
SET i_id23 = 0;
SET i_title23 = '';
SET i_publisher23 = '';
SET i_cost23 = 0;
SET ol_qty23 = 0;
SET ol_discount23 = 0;
SET ol_comments23 = '';
SET i_id24 = 0;
SET i_title24 = '';
SET i_publisher24 = '';
SET i_cost24 = 0;
SET ol_qty24 = 0;
SET ol_discount24 = 0;
SET ol_comments24 = '';
SET i_id25 = 0;
SET i_title25 = '';
SET i_publisher25 = '';
SET i_cost25 = 0;
SET ol_qty25 = 0;
SET ol_discount25 = 0;
SET ol_comments25 = '';
SET i_id26 = 0;
SET i_title26 = '';
SET i_publisher26 = '';
SET i_cost26 = 0;
SET ol_qty26 = 0;
SET ol_discount26 = 0;
SET ol_comments26 = '';
SET i_id27 = 0;
SET i_title27 = '';
SET i_publisher27 = '';
SET i_cost27 = 0;
SET ol_qty27 = 0;
SET ol_discount27 = 0;
SET ol_comments27 = '';
SET i_id28 = 0;
SET i_title28 = '';
SET i_publisher28 = '';
SET i_cost28 = 0;
SET ol_qty28 = 0;
SET ol_discount28 = 0;
SET ol_comments28 = '';
SET i_id29 = 0;
SET i_title29 = '';
SET i_publisher29 = '';
SET i_cost29 = 0;
SET ol_qty29 = 0;
SET ol_discount29 = 0;
SET ol_comments29 = '';
SET i_id30 = 0;
SET i_title30 = '';
SET i_publisher30 = '';
SET i_cost30 = 0;
SET ol_qty30 = 0;
SET ol_discount30 = 0;
SET ol_comments30 = '';
END;
;
DROP DBPROC getOrderItems;
/* Clause 2.9.3 */
CREATE DBPROC getOrderItems(
IN o_id fixed(10,0), OUT num_item fixed(3,0),
OUT i_id1 FIXED(10), OUT i_title1 VARCHAR(60),
OUT i_publisher1 VARCHAR(60), OUT i_cost1 FIXED(17, 2),
OUT ol_qty1 FIXED(3), OUT ol_discount1 FIXED(17, 2),
OUT ol_comments1 VARCHAR(100),
OUT i_id2 FIXED(10), OUT i_title2 VARCHAR(60),
OUT i_publisher2 VARCHAR(60), OUT i_cost2 FIXED(17, 2),
OUT ol_qty2 FIXED(3), OUT ol_discount2 FIXED(17, 2),
OUT ol_comments2 VARCHAR(100),
OUT i_id3 FIXED(10), OUT i_title3 VARCHAR(60),
OUT i_publisher3 VARCHAR(60), OUT i_cost3 FIXED(17, 2),
OUT ol_qty3 FIXED(3), OUT ol_discount3 FIXED(17, 2),
OUT ol_comments3 VARCHAR(100),
OUT i_id4 FIXED(10), OUT i_title4 VARCHAR(60),
OUT i_publisher4 VARCHAR(60), OUT i_cost4 FIXED(17, 2),
OUT ol_qty4 FIXED(3), OUT ol_discount4 FIXED(17, 2),
OUT ol_comments4 VARCHAR(100),
OUT i_id5 FIXED(10), OUT i_title5 VARCHAR(60),
OUT i_publisher5 VARCHAR(60), OUT i_cost5 FIXED(17, 2),
OUT ol_qty5 FIXED(3), OUT ol_discount5 FIXED(17, 2),
OUT ol_comments5 VARCHAR(100),
OUT i_id6 FIXED(10), OUT i_title6 VARCHAR(60),
OUT i_publisher6 VARCHAR(60), OUT i_cost6 FIXED(17, 2),
OUT ol_qty6 FIXED(3), OUT ol_discount6 FIXED(17, 2),
OUT ol_comments6 VARCHAR(100),
OUT i_id7 FIXED(10), OUT i_title7 VARCHAR(60),
OUT i_publisher7 VARCHAR(60), OUT i_cost7 FIXED(17, 2),
OUT ol_qty7 FIXED(3), OUT ol_discount7 FIXED(17, 2),
OUT ol_comments7 VARCHAR(100),
OUT i_id8 FIXED(10), OUT i_title8 VARCHAR(60),
OUT i_publisher8 VARCHAR(60), OUT i_cost8 FIXED(17, 2),
OUT ol_qty8 FIXED(3), OUT ol_discount8 FIXED(17, 2),
OUT ol_comments8 VARCHAR(100),
OUT i_id9 FIXED(10), OUT i_title9 VARCHAR(60),
OUT i_publisher9 VARCHAR(60), OUT i_cost9 FIXED(17, 2),
OUT ol_qty9 FIXED(3), OUT ol_discount9 FIXED(17, 2),
OUT ol_comments9 VARCHAR(100),
OUT i_id10 FIXED(10), OUT i_title10 VARCHAR(60),
OUT i_publisher10 VARCHAR(60), OUT i_cost10 FIXED(17, 2),
OUT ol_qty10 FIXED(3), OUT ol_discount10 FIXED(17, 2),
OUT ol_comments10 VARCHAR(100),
OUT i_id11 FIXED(10), OUT i_title11 VARCHAR(60),
OUT i_publisher11 VARCHAR(60), OUT i_cost11 FIXED(17, 2),
OUT ol_qty11 FIXED(3), OUT ol_discount11 FIXED(17, 2),
OUT ol_comments11 VARCHAR(100),
OUT i_id12 FIXED(10), OUT i_title12 VARCHAR(60),
OUT i_publisher12 VARCHAR(60), OUT i_cost12 FIXED(17, 2),
OUT ol_qty12 FIXED(3), OUT ol_discount12 FIXED(17, 2),
OUT ol_comments12 VARCHAR(100),
OUT i_id13 FIXED(10), OUT i_title13 VARCHAR(60),
OUT i_publisher13 VARCHAR(60), OUT i_cost13 FIXED(17, 2),
OUT ol_qty13 FIXED(3), OUT ol_discount13 FIXED(17, 2),
OUT ol_comments13 VARCHAR(100),
OUT i_id14 FIXED(10), OUT i_title14 VARCHAR(60),
OUT i_publisher14 VARCHAR(60), OUT i_cost14 FIXED(17, 2),
OUT ol_qty14 FIXED(3), OUT ol_discount14 FIXED(17, 2),
OUT ol_comments14 VARCHAR(100),
OUT i_id15 FIXED(10), OUT i_title15 VARCHAR(60),
OUT i_publisher15 VARCHAR(60), OUT i_cost15 FIXED(17, 2),
OUT ol_qty15 FIXED(3), OUT ol_discount15 FIXED(17, 2),
OUT ol_comments15 VARCHAR(100),
OUT i_id16 FIXED(10), OUT i_title16 VARCHAR(60),
OUT i_publisher16 VARCHAR(60), OUT i_cost16 FIXED(17, 2),
OUT ol_qty16 FIXED(3), OUT ol_discount16 FIXED(17, 2),
OUT ol_comments16 VARCHAR(100),
OUT i_id17 FIXED(10), OUT i_title17 VARCHAR(60),
OUT i_publisher17 VARCHAR(60), OUT i_cost17 FIXED(17, 2),
OUT ol_qty17 FIXED(3), OUT ol_discount17 FIXED(17, 2),
OUT ol_comments17 VARCHAR(100),
OUT i_id18 FIXED(10), OUT i_title18 VARCHAR(60),
OUT i_publisher18 VARCHAR(60), OUT i_cost18 FIXED(17, 2),
OUT ol_qty18 FIXED(3), OUT ol_discount18 FIXED(17, 2),
OUT ol_comments18 VARCHAR(100),
OUT i_id19 FIXED(10), OUT i_title19 VARCHAR(60),
OUT i_publisher19 VARCHAR(60), OUT i_cost19 FIXED(17, 2),
OUT ol_qty19 FIXED(3), OUT ol_discount19 FIXED(17, 2),
OUT ol_comments19 VARCHAR(100),
OUT i_id20 FIXED(10), OUT i_title20 VARCHAR(60),
OUT i_publisher20 VARCHAR(60), OUT i_cost20 FIXED(17, 2),
OUT ol_qty20 FIXED(3), OUT ol_discount20 FIXED(17, 2),
OUT ol_comments20 VARCHAR(100),
OUT i_id21 FIXED(10), OUT i_title21 VARCHAR(60),
OUT i_publisher21 VARCHAR(60), OUT i_cost21 FIXED(17, 2),
OUT ol_qty21 FIXED(3), OUT ol_discount21 FIXED(17, 2),
OUT ol_comments21 VARCHAR(100),
OUT i_id22 FIXED(10), OUT i_title22 VARCHAR(60),
OUT i_publisher22 VARCHAR(60), OUT i_cost22 FIXED(17, 2),
OUT ol_qty22 FIXED(3), OUT ol_discount22 FIXED(17, 2),
OUT ol_comments22 VARCHAR(100),
OUT i_id23 FIXED(10), OUT i_title23 VARCHAR(60),
OUT i_publisher23 VARCHAR(60), OUT i_cost23 FIXED(17, 2),
OUT ol_qty23 FIXED(3), OUT ol_discount23 FIXED(17, 2),
OUT ol_comments23 VARCHAR(100),
OUT i_id24 FIXED(10), OUT i_title24 VARCHAR(60),
OUT i_publisher24 VARCHAR(60), OUT i_cost24 FIXED(17, 2),
OUT ol_qty24 FIXED(3), OUT ol_discount24 FIXED(17, 2),
OUT ol_comments24 VARCHAR(100),
OUT i_id25 FIXED(10), OUT i_title25 VARCHAR(60),
OUT i_publisher25 VARCHAR(60), OUT i_cost25 FIXED(17, 2),
OUT ol_qty25 FIXED(3), OUT ol_discount25 FIXED(17, 2),
OUT ol_comments25 VARCHAR(100),
OUT i_id26 FIXED(10), OUT i_title26 VARCHAR(60),
OUT i_publisher26 VARCHAR(60), OUT i_cost26 FIXED(17, 2),
OUT ol_qty26 FIXED(3), OUT ol_discount26 FIXED(17, 2),
OUT ol_comments26 VARCHAR(100),
OUT i_id27 FIXED(10), OUT i_title27 VARCHAR(60),
OUT i_publisher27 VARCHAR(60), OUT i_cost27 FIXED(17, 2),
OUT ol_qty27 FIXED(3), OUT ol_discount27 FIXED(17, 2),
OUT ol_comments27 VARCHAR(100),
OUT i_id28 FIXED(10), OUT i_title28 VARCHAR(60),
OUT i_publisher28 VARCHAR(60), OUT i_cost28 FIXED(17, 2),
OUT ol_qty28 FIXED(3), OUT ol_discount28 FIXED(17, 2),
OUT ol_comments28 VARCHAR(100),
OUT i_id29 FIXED(10), OUT i_title29 VARCHAR(60),
OUT i_publisher29 VARCHAR(60), OUT i_cost29 FIXED(17, 2),
OUT ol_qty29 FIXED(3), OUT ol_discount29 FIXED(17, 2),
OUT ol_comments29 VARCHAR(100),
OUT i_id30 FIXED(10), OUT i_title30 VARCHAR(60),
OUT i_publisher30 VARCHAR(60), OUT i_cost30 FIXED(17, 2),
OUT ol_qty30 FIXED(3), OUT ol_discount30 FIXED(17, 2),
OUT ol_comments30 VARCHAR(100)) AS
BEGIN
set num_item=0;
CALL initOrderItems(
:i_id1, :i_title1, :i_publisher1, :i_cost1, :ol_qty1, :ol_discount1, :ol_comments1,
:i_id2, :i_title2, :i_publisher2, :i_cost2, :ol_qty2, :ol_discount2, :ol_comments2,
:i_id3, :i_title3, :i_publisher3, :i_cost3, :ol_qty3, :ol_discount3, :ol_comments3,
:i_id4, :i_title4, :i_publisher4, :i_cost4, :ol_qty4, :ol_discount4, :ol_comments4,
:i_id5, :i_title5, :i_publisher5, :i_cost5, :ol_qty5, :ol_discount5, :ol_comments5,
:i_id6, :i_title6, :i_publisher6, :i_cost6, :ol_qty6, :ol_discount6, :ol_comments6,
:i_id7, :i_title7, :i_publisher7, :i_cost7, :ol_qty7, :ol_discount7, :ol_comments7,
:i_id8, :i_title8, :i_publisher8, :i_cost8, :ol_qty8, :ol_discount8, :ol_comments8,
:i_id9, :i_title9, :i_publisher9, :i_cost9, :ol_qty9, :ol_discount9, :ol_comments9,
:i_id10, :i_title10, :i_publisher10, :i_cost10, :ol_qty10, :ol_discount10, :ol_comments10,
:i_id11, :i_title11, :i_publisher11, :i_cost11, :ol_qty11, :ol_discount11, :ol_comments11,
:i_id12, :i_title12, :i_publisher12, :i_cost12, :ol_qty12, :ol_discount12, :ol_comments12,
:i_id13, :i_title13, :i_publisher13, :i_cost13, :ol_qty13, :ol_discount13, :ol_comments13,
:i_id14, :i_title14, :i_publisher14, :i_cost14, :ol_qty14, :ol_discount14, :ol_comments14,
:i_id15, :i_title15, :i_publisher15, :i_cost15, :ol_qty15, :ol_discount15, :ol_comments15,
:i_id16, :i_title16, :i_publisher16, :i_cost16, :ol_qty16, :ol_discount16, :ol_comments16,
:i_id17, :i_title17, :i_publisher17, :i_cost17, :ol_qty17, :ol_discount17, :ol_comments17,
:i_id18, :i_title18, :i_publisher18, :i_cost18, :ol_qty18, :ol_discount18, :ol_comments18,
:i_id19, :i_title19, :i_publisher19, :i_cost19, :ol_qty19, :ol_discount19, :ol_comments19,
:i_id20, :i_title20, :i_publisher20, :i_cost20, :ol_qty20, :ol_discount20, :ol_comments20,
:i_id21, :i_title21, :i_publisher21, :i_cost21, :ol_qty21, :ol_discount21, :ol_comments21,
:i_id22, :i_title22, :i_publisher22, :i_cost22, :ol_qty22, :ol_discount22, :ol_comments22,
:i_id23, :i_title23, :i_publisher23, :i_cost23, :ol_qty23, :ol_discount23, :ol_comments23,
:i_id24, :i_title24, :i_publisher24, :i_cost24, :ol_qty24, :ol_discount24, :ol_comments24,
:i_id25, :i_title25, :i_publisher25, :i_cost25, :ol_qty25, :ol_discount25, :ol_comments25,
:i_id26, :i_title26, :i_publisher26, :i_cost26, :ol_qty26, :ol_discount26, :ol_comments26,
:i_id27, :i_title27, :i_publisher27, :i_cost27, :ol_qty27, :ol_discount27, :ol_comments27,
:i_id28, :i_title28, :i_publisher28, :i_cost28, :ol_qty28, :ol_discount28, :ol_comments28,
:i_id29, :i_title29, :i_publisher29, :i_cost29, :ol_qty29, :ol_discount29, :ol_comments29,
:i_id30, :i_title30, :i_publisher30, :i_cost30, :ol_qty30, :ol_discount30, :ol_comments30);
SELECT ol_i_id, i_title, i_publisher, i_cost, ol_qty, ol_discount,
ol_comments
FROM tpcw.item, tpcw.order_line
WHERE ol_o_id = :o_id AND ol_i_id = i_id;
if $rc=0 THEN
FETCH into :i_id1, :i_title1, :i_publisher1, :i_cost1, :ol_qty1,
:ol_discount1, :ol_comments1;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id2, :i_title2, :i_publisher2, :i_cost2, :ol_qty2,
:ol_discount2, :ol_comments2;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id3, :i_title3, :i_publisher3, :i_cost3, :ol_qty3,
:ol_discount3, :ol_comments3;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id4, :i_title4, :i_publisher4, :i_cost4, :ol_qty4,
:ol_discount4, :ol_comments4;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id5, :i_title5, :i_publisher5, :i_cost5, :ol_qty5,
:ol_discount5, :ol_comments5;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id6, :i_title6, :i_publisher6, :i_cost6, :ol_qty6,
:ol_discount6, :ol_comments6;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id7, :i_title7, :i_publisher7, :i_cost7, :ol_qty7,
:ol_discount7, :ol_comments7;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id8, :i_title8, :i_publisher8, :i_cost8, :ol_qty8,
:ol_discount8, :ol_comments8;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id9, :i_title9, :i_publisher9, :i_cost9, :ol_qty9,
:ol_discount9, :ol_comments9;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id10, :i_title10, :i_publisher10, :i_cost10, :ol_qty10,
:ol_discount10, :ol_comments10;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id11, :i_title11, :i_publisher11, :i_cost11, :ol_qty11,
:ol_discount11, :ol_comments11;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id12, :i_title12, :i_publisher12, :i_cost12, :ol_qty12,
:ol_discount12, :ol_comments12;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id13, :i_title13, :i_publisher13, :i_cost13, :ol_qty13,
:ol_discount13, :ol_comments13;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id14, :i_title14, :i_publisher14, :i_cost14, :ol_qty14,
:ol_discount14, :ol_comments14;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id15, :i_title15, :i_publisher15, :i_cost15, :ol_qty15,
:ol_discount15, :ol_comments15;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id16, :i_title16, :i_publisher16, :i_cost16, :ol_qty16,
:ol_discount16, :ol_comments16;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id17, :i_title17, :i_publisher17, :i_cost17, :ol_qty17,
:ol_discount17, :ol_comments17;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id18, :i_title18, :i_publisher18, :i_cost18, :ol_qty18,
:ol_discount18, :ol_comments18;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id19, :i_title19, :i_publisher19, :i_cost19, :ol_qty19,
:ol_discount19, :ol_comments19;
end;
if $rc=0 THEN begin
set num_item=num_item+1;
FETCH into :i_id20, :i_title20, :i_publisher20, :i_cost20, :ol_qty20,
:ol_discount20, :ol_comments20;
end;
END;
;
