Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
221 vnguyen 1 
DECLARE
2 
  TEMP_COUNT NUMBER;
3 
  SQLSTR VARCHAR2(200);
4 
BEGIN
5 
  SQLSTR := 'ALTER USER "RELEASE_MANAGER" QUOTA UNLIMITED ON "USERS"';
6 
  EXECUTE IMMEDIATE SQLSTR;
7 
EXCEPTION
8 
  WHEN OTHERS THEN
9 
    IF SQLCODE = -30041 THEN
10 
      SQLSTR := 'SELECT COUNT(*) FROM USER_TABLESPACES
11 
              WHERE TABLESPACE_NAME = ''USERS'' AND CONTENTS = ''TEMPORARY''';
12 
      EXECUTE IMMEDIATE SQLSTR INTO TEMP_COUNT;
13 
      IF TEMP_COUNT = 1 THEN RETURN;
14 
      ELSE RAISE;
15 
      END IF;
16 
    ELSE
17 
      RAISE;
18 
    END IF;
19 
END;
20 
/
21