over 4 years ago

oracl SQL 出現 Exception

java.sql.SQLException: ORA-30004: when using SYS_CONNECT_BY_PATH function, cannot have seperator as part of column value

主要是執行 sys_connect_by_path(FolderName,'/') 出錯
原因是 FolderName 欄位裡面有包含 '/' 字串造成 sys_connect_by_path 解析錯誤

← struts2 Validator 不起作用 ReactJS 與 Flux 練習 →
 
comments powered by Disqus