Hello everybody;
I would like to know how to do a like clause to bind variables, with this code i obtain 'ORA-00933: SQL command not properly ended' error
:
v_query:= 'UPDATE ' || collection(i) ||' SET REF_PLAN=:quatre_champ WHERE FAM_SIM like ''%'':prem_champ''%'' AND PRISE_V1P like ''%'':deux_champ''%'' AND BROCHE_V1P like ''%:trois_champ%''';
EXECUTE IMMEDIATE v_query USING quatre_champ,prem_champ,deux_champ,trois_champ;
Maybe my " ' " are in a bad positions ?
Thanks for your help, regards.