oracle - Error in dynamic SQL query. Missing expression with correct syntax -
i have problem working stored procedure on work. it's stored procedure used several bigger procedures. procedure work called c , , ones call a , b . the problem have when run a , goes smoothly, when run b , missing expression error , don't when call a , tough b , a have same flow of procedure calls (so, it's kind of weird error). the c procedure has same code: procedure c ( lo in varchar2, en in varchar2, ca in array1d, ia in number, ar in array2d ) cq varchar2(5); et varchar2(2000); ol varchar2(100); ne varchar2(100); te varchar2(100); xu varchar2(100); begin lo := '05'; te := 'var'; cq := ''''; ol := cq || lo || cq; te := cq || te || cq; ne := cq || en || cq; et := 'par1 = ' || ca(1) || ',' || 'par2 = ' || ca(2) || ',' || 'par3 = ' || ca(3) || ',' || 'par4 = ' || c...