I'm trying the following:
function func_recordsdb_used return varchar2
iv_value varchar2(5) ;
select count(*) INTO iv_exist from dba_tables where table_name ='ODM_RECORD';
IF iv_exist > 0 THEN
iv_recordsdb := 0;
IF iv_recordsdb > 0 THEN
iv_value := 'TRUE';
iv_value := 'FALSE';
I get a error because odm_record isn't there but that shouldn't be a problem because it won't be reached when the iv_exist variable is 0.
How can I work around this problem?