DB2 Stored Procedure Returning Too many rows -

i have extremely simple stored procedure find tables in specific schema based on schema , table parameters.

the problem stored procedure returns of rows table.

• it ignores second parameter (table_name)
• i can misspell table_name parameter , procedure returns rows.
• if misspell schema parameter not return rows.

any ideas? in advance. stored procedure below.

create or replace procedure findtablecolumns  (in schema varchar(25), in table_name varchar(25)) language sql reads sql data result sets 1  begin    declare column_table_list cursor return caller     select         row_number ( ) on ( order table_name , ordinal_position ) #         ,table_name        ,column_name        ,system_column_name        ,data_type        ,length        ,column_text   qsys2 . syscolumns   table_schema = upper ( schema ) , table_name = upper ( table_name )   read ;    open column_table_list ; end  

i think because columnname , parametername equal. can solve it:

create or replace procedure findtablecolumns  (in schema varchar(25), in table_name_par varchar(25)) language sql reads sql data result sets 1 begin declare column_table_list cursor return caller select     row_number ( ) on ( order table_name , ordinal_position ) #     ,table_name    ,column_name    ,system_column_name    ,data_type    ,length    ,column_text qsys2 . syscolumns table_schema = upper ( schema ) , table_name = upper ( table_name_par ) read ; open column_table_list ; end