declare
    cursor testv is
    select code_combination_id,account_type
    from gl_code_combinations;
    Type rec_gl_periods is Record(ccid gl_code_combinations.code_combination_id%Type,
    descr gl_code_combinations.account_type%Type
    );
        recs rec_gl_periods;
        testrow testv%rowtype;
begin
    open testv;
    loop
    fetch testv into testrow;
    exit when testv%notfound;
    message (testrow.code_combination_id);
    message(testrow.account_type);
   
    end loop;
    null;
    end;
Monday, January 11, 2010
Subscribe to:
Post Comments (Atom)
 
I would like to be a member of this blog.Its a great site to have knowledge about the various new apps development programs. It also gives many useful tips.
ReplyDeletesap support package stack