create or replace procedure strToken is
int var_count:=0;
int var_count1:=0;
begin
with t as (select code from company where code='1111')
SELECT (select count(1) from company_extend where code in (select code from t))
,(select count(1) from company_bank where code in (select code from t))
INTO var_count,var_count1
FROM DUAL;
end;
/
int var_count:=0;
int var_count1:=0;
begin
with t as (select code from company where code='1111')
SELECT (select count(1) from company_extend where code in (select code from t))
,(select count(1) from company_bank where code in (select code from t))
INTO var_count,var_count1
FROM DUAL;
end;
/