Database

INSERT INTO TEST VALUES(SELECT SEQ_INDI.NEXTVAL FROM DUAL,SELECT NAME FROM TEST);

IF MTM_ACTV_SETS.SETS LIKE '%_R%'  OR MTM_ACTV_SETS.SETS LIKE '%_L%'
BEGIN 
DELETE TBL_CLASH_ACTV
FROM MTM_ACTV_SETS AS1
INNER JOIN MTM_ACTV_SETS AS2 ON AS2.SETS=AS1.SETS
INNER JOIN TBL_CLASH_ACTV CA ON CA.ACTV1=AS1.ACTV AND CA.ACTV2=AS2.ACTV
WHERE AS1.ACTV <> AS2.ACTV
END 

Msg 4104, Level 16, State 1, Line 2
The multi-part identifier "MTM_ACTV_SETS.SETS" could not be bound.
Msg 4104, Level 16, State 1, Line 2
The multi-part identifier "MTM_ACTV_SETS.SETS" could not be bound.

SQL> SELECT PRIVILEGE FROM DBA_SYS_PRIVS WHERE GRANTEE = 'U';

PRIVILEGE
----------------------------------------
CREATE SESSION

SQL> SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'U';

no rows selected

SQL> 

id     uname
1       Évian-les-Bains
2       Évreux
3       Eysines
4       Île d?Aix
5       L?Isle-d?Abeau

ALTER PROC GET_BASED_PATTERN
(
@SUBJECT VARCHAR(30),
@Pattern  nvarchar(128) output 
)
AS
SET @Pattern = (SELECT TOP 1 TERM.[CYCLETEMPLATES]FROM tbl_term TERM 
INNER JOIN dbo.TBL_ACTV v
on TERM.ID = V.TERM
INNER JOIN  DBO._Subjects S
ON V.TERM = S.[LEVEL]
WHERE CODE = @SUBJECT)
SELECT 
CASE 
WHEN LEN(@Pattern) > 1 THEN @Pattern
ELSE '00000000'
END

00000000