news wrote: > > Hi, > > I am trying to explode bill of materials using Recursive DECLARE CURSOR > statement explained in docs. Following is the stored procedure- > > CREATE DBPROC bom (IN main_item VARCHAR(25)) RETURNS CURSOR AS > > $CURSOR = 'bom'; > > BEGIN > > DECLARE :$CURSOR CURSOR FOR > WITH RECURSIVE PX (main, sub, qty, super_main) AS > (SELECT main_item_code, sub_item_code, sub_item_qty, > main_item_code > FROM suman.mfg_latest_bom_v WHERE main_item_code = :main_item > UNION ALL > SELECT main_item_code, sub_item_code, sub_item_qty, super_main > FROM suman.mfg_latest_bom_v B, suman.PX > WHERE sub = B.main_item_code) > SELECT super_main, sub, qty FROM suman.PX ORDER BY 1, 2; > > END; > > this gives me foloowing error- > > General error;-9205 POS(80) System error: AK Catalog information not > found:FF000006000A0020008900. > > (DECLARE keyword is highlighted in SQL Studio). > > Any help is greatly appreciated.
As I do not know what may have happened and not able to reproduce this effect: Please upgrade to the newest version of the kernel (perhaps even to 7.5.00). Please tell me/us if the problem remains, send me the table/view-definition of the table/view(s) (mfg_latest_bom_v sounds like a view, may be it is a little bit complicated and may cause the problem...) involved, tell us which sqlmode you are using (the error occures during DEFINITION of the dbproc, doesn't it?) if you can select the table in a pure way (select * from mfg_latest_bom_v) Thank you Elke SAP Labs Berlin > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
