PL/SQL (MOSC)

MOSC Banner

NO Error but also no result

in PL/SQL (MOSC) 3 commentsAnswered ✓

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production


I am trying to change the STATUS of a tablespace using PL/SQL - need to make call in Linux.

--------------------------------------------------------------------------------------------

FUNCTION EXT_WEB_ONOFF(XSWITCH IN INTEGER) RETURN VARCHAR2 IS

  RET     VARCHAR2(100);

  CSTAT    VARCHAR2(1);

  XDO     VARCHAR2(2) := TO_CHAR(XSWITCH);

  EXEC_STR  VARCHAR2(100);

BEGIN

  SELECT CASE STATUS WHEN 'ONLINE' THEN '1' WHEN 'READ ONLY' THEN '0' END

   INTO CSTAT

   FROM DBA_TABLESPACES

  WHERE TABLESPACE_NAME = 'EXT_WEB';

  XDO := CSTAT || XDO;

  CASE WHEN (XDO = '01') THEN

      EXEC_STR := 'ALTER TABLESPACE EXT_WEB READ WRITE';

    WHEN (XDO = '10') THEN

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center