7: -- check to make sure given name IS a real table
8: -- Added one more cursor parameter owner for UDTF standards by KH 3431801
9:
10: CURSOR l_table_cur(c_tablename user_tables.table_name%TYPE,
11: c_schema_owner all_tables.owner%TYPE) IS
12: SELECT 1
13: FROM ALL_TABLES
14: --MADE by Khaja added one OWNER on where clause for UDTF bug fix #3431801
15: --MADE by Khaja FROM user_tables
9:
10: CURSOR l_table_cur(c_tablename user_tables.table_name%TYPE,
11: c_schema_owner all_tables.owner%TYPE) IS
12: SELECT 1
13: FROM ALL_TABLES
14: --MADE by Khaja added one OWNER on where clause for UDTF bug fix #3431801
15: --MADE by Khaja FROM user_tables
16: WHERE table_name = upper(c_tablename)
17: and owner=c_schema_owner;