G
G
Grigory Skvortsov2020-10-25 17:18:42
Oracle
Grigory Skvortsov, 2020-10-25 17:18:42

Where can there be an error here (the procedure compiles fine)?

I don't see an error, but there is one.

PROCEDURE REPL_TABLE(idtab in number default -1)
 as
begin
 for cc in ( select id_repl_table, xxx
                from repl_table_list
               order by srt, id_repl_table
            )
  loop
   if (cc.id_repl_table = idtab) then
     REPL_TABLE_BSM1(cc.id_repl_table, cc.xxx);
   end if;
  end loop;
end;


Thank you!

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question