Call

Question

Does anyone know a method to call a dynamic process?

I am creating an html/css/javascript screen in an oracle database. I created a table with the names of the procedures I want to call. That way when there is a new functionality in the system, do not need to change the main code only add the name of the past in the table.

More or less like this

for c_dados in (select * from tabela where flag = 'S') loop

        htp.p('<div class="brick large" id="'||c_dados.id||'">');
      exxecute immediate 'begin'|| c_dados.nome_proc||'; end;';
         htp.p('</div> ');

     end loop;

But running immediate does not work. Does anyone know any other way?

Answer 1

nonsense my was missing a space after Begin

execute immediate 'begin '|| c_dados.nome_proc||'; end;';