查询用到指定表的视图和存储过程

查询用到指定表的视图和存储过程

CREATE PROCEDURE P_LOOP_TABLE_PRO_VIEW(
IN V_TABLE VARCHAR(5000),
OUT result_code INT,
OUT result_msg VARCHAR(500)
)
LANGUAGE SQL
NOT DETERMINISTIC
CONTAINS SQL
SQL SECURITY DEFINER
COMMENT ‘’
BEGIN

DECLARE V_INFO VARCHAR(500);
DECLARE V_CH VARCHAR(600);
DECLARE flag INT DEFAULT 0;

DECLARE CUR CURSOR FOR (

select t1.table_name,t.table_comment
FROM(
select REPLACE(replace(substring_index(substring_index(a.info,’,’,id+1),’,’,’-1’),’ ‘,’’),’ ‘,’’) table_name
from (
SELECT lower(V_TABLE) INFO
) a
join
(select id from mrda_plan_seq_table) b
on id<=length(a.info)-length(replace(a.info,’,’,’’))
)t1
left join information_schema.tables t
on t.table_type=‘BASE TABLE’ AND TABLE_SCHEMA=‘epm_rd’ and t.table_name=t1.table_name