CREATE OR REPLACE FUNCTION "F_COMPRARE_DM" (own in varchar2,
table_na in varchar2,
bz in varchar2,
CONTENT IN VARCHAR2)
return varchar2 is
Result VARCHAR2(4000);
cursor col is
select column_name,data_type from dba_tab_cols where t.owner = own
and table_name = table_na;
v_col_all varchar2(4000) := null;
v_con varchar2(4000);
v_con_all varchar2(4000) := null;
v_col varchar2(4000);
v_data_type varchar2(30); //===
老是提示表或视图不存在,可是这个dba_tab_cols 有呀,而且我已经给了权限grant select any dictionary to youruser; 我又用SYSTEM用户也编译不过去
table_na in varchar2,
bz in varchar2,
CONTENT IN VARCHAR2)
return varchar2 is
Result VARCHAR2(4000);
cursor col is
select column_name,data_type from dba_tab_cols where t.owner = own
and table_name = table_na;
v_col_all varchar2(4000) := null;
v_con varchar2(4000);
v_con_all varchar2(4000) := null;
v_col varchar2(4000);
v_data_type varchar2(30); //===
老是提示表或视图不存在,可是这个dba_tab_cols 有呀,而且我已经给了权限grant select any dictionary to youruser; 我又用SYSTEM用户也编译不过去
2.授权
hint: prarmeter 'content' is decleared but never suer in 'F_COMPRARE_DM'
hint: variable 'v_con' is decleared but never user in 'F_COMPRARE_DM'
hint :variable 'v_con_all' is decleared but never user in 'F_COMPRARE_DM'