[重庆思庄每日技术分享]-创建物化视图时出现ORA-7445错误

根据官方文档（ID:2267661.1）

在oracle12.1.0.2及之后版本上创建物化视图时可能会出现报错：

ORA 7445 [qsme_pls_string] during create mview with XML type functions.

STACK

skdstdst <- ksedst <- dbkedDefDump <- ksedmp <- ssexhd

<- sslsshandler <- sighandler <- qsme_pls_string <- qsme_expr_string

<- 1338

<- qsme_expr_string <- 1563 <- qsme_opn_to_text <-

qsmkzik_init_qsmksk <- qsmkzcc_correlate_s

<- um_cols <- qsmkzss_sum_setup_q <- qsmkzss_setup_summa <-

qsmkzsm_summary_sem <- antics_and_metadata

<- kkmpqaq <- kkmpqcbk <- qcspqbDescendents <- qcspqb <- kkmdrv

<- opiSem <- opiprs <- kksParseChildCursor <- rpiswu2 <-

kksLoadChild

<- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <-

opiosq0

<- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino

<- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain

<- main <- libc_start_main <- start

出现这个报错的的原因是BUG  25495749

于是解决方法便是安装对应此bug的补丁包