WITH t AS
(
SELECT 'SLEEVE-INNER DH36 OD:189X11TX75L 150A JS' pname FROM dual
UNION ALL SELECT 'SLEEVE-INNER DH36 OD:163X10TX75L 5"(125A' FROM dual
UNION ALL SELECT 'ELBOW 45-SR WELD PG370 BE 12.7T 250A MTR' FROM dual
UNION ALL SELECT 'PIPE ERW PE STPG370 #80 6M 125A MTR' FROM dual
UNION ALL SELECT 'PIPE ERW PE STPG370 #80 6M 150A MTR' FROM dual
UNION ALL SELECT 'PIPE ERW PE STPG370 12.7T 6M 250A MTR' FROM dual
UNION ALL SELECT 'PIPE ERW PE STPG370 12.7T 6M 250A MTR' FROM dual
)
SELECT pname
     , REGEXP_SUBSTR(pname, '[0-9.]+A') a
     , REGEXP_SUBSTR(pname, '#+[0-9.].') b
     , REGEXP_SUBSTR(pname, '[0-9.]+M') m
     , REGEXP_SUBSTR(pname, '[0-9.]+T') t
  FROM t
;

, REGEXP_SUBSTR(pname, '#+[0-9.].') b    --- > ibatis에서는 어떻게 처리해야 가능한가요  

#80 으로 출력이 필요한데...

위 쿼리로 Editor tool에서는 정상적으로 출력이 되는데

com.ibatis.sqlmap.client.SqlMapException: Unrecognized parameter mapping field: ' 로 오류가 떨어지네요

한수 가르쳐 주시면 감사하겠습니다.

수고하세요^^;