Recursive DECLARE CURSOR statement

[QA]

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.




-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]