Bonjour, voici mon code:
DECLARE
CURSOR C_TARGET IS
select distinct TARGET from map where CODE is NULL;
CURSOR C_CHANGE;
A_COUNT NUMBER(15);
BEGIN
FOR target IN C_TARGET
EXECUTE IMMEDIATE('ALTER SESSION SET CURRENT_SCHEMA=' || target.TARGET);
OPEN C_CHANGE FOR 'select count(*) from CHANGE where (MODE='MANUAL')';
FETCH C_CHANGE INTO A_COUNT;
CLOSE C_CHANGE;
END LOOP;
END;
/
J'obtiens l'erreur suivante:
PLS-00103: Encountered the symbol "MANUAL" when expecting one of the following:
* & = - + ; < / > at in is mod remainder not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between using || multiset member SUBMULTISET_
Merci de m'aider
Partager