Oracle oci8 存取CLOB欄位

php clob ocacle updateclob

king742171 2017-05-09 14:43:33 ‧ 5975 瀏覽

分享至

"exception 'ADODB_Exception' with message 'oci8 error: [933: ORA-00933: SQL command not properly ended] in EXECUTE(\"UPDATE YC_NPV_NOTEBA set xl_text=EMPTY_CLOB() WHERE id_formseq=123456NOTE20170509143953 RETURNING xl_text INTO :blob\")\n' in \/var\/www\/html\/medical_draw\/adodb5\/adodb-exceptions.inc.php:78\nStack trace:\n#0 \/var\/www\/html\/medical_draw\/adodb5\/adodb.inc.php(1074): adodb_throw('oci8', 'EXECUTE', 933, 'ORA-00933: SQL ...', 'UPDATE YC_NPV_N...', Array, Object(ADODB_oci8))\n#1 \/var\/www\/html\/medical_draw\/adodb5\/drivers\/adodb-oci8.inc.php(756): ADOConnection->_Execute('UPDATE YC_NPV_N...', Array)\n#2 \/var\/www\/html\/medical_draw\/adodb5\/adodb.inc.php(2078): ADODB_oci8->UpdateBlob('YC_NPV_NOTEBA', 'xl_text', '{\"nm_patient\":\"...', 'id_formseq=1234...', 'CLOB')\n#3 \/var\/www\/html\/medical_draw\/php\/ws\/noteSave.php(89): ADOConnection->UpdateClob('YC_NPV_NOTEBA', 'xl_text', '{\"nm_patient\":\"...', 'id_formseq=1234...')\n#4 {main}"

我在執行UpdateClob函式後
出現這段訊息~
哪位大大願意為我解釋一下？= =
（PS：我是用PHP在撰寫後端的）

wonton iT邦高手 6 級 ‧ 2017-05-10 09:49:48 檢舉

錯誤訊息這樣看應該清楚點? 它回報是 SQL command not properly ended
所以錯誤可能出現在你的 RETURNING 後面的語句吧。

"
exception 'ADODB_Exception' with message

'
oci8 error: [933: ORA-00933: SQL command not properly ended]
in EXECUTE("UPDATE YC_NPV_NOTEBA set xl_text=EMPTY_CLOB() WHERE id_formseq=123456NOTE20170509143953 RETURNING xl_text INTO :blob")
'

in /var/www/html/medical_draw/adodb5/adodb-exceptions.inc.php:78
Stack trace:
#0 /var/www/html/medical_draw/adodb5/adodb.inc.php(1074): adodb_throw('oci8', 'EXECUTE', 933, 'ORA-00933: SQL ...', 'UPDATE YC_NPV_N...', Array, Object(ADODB_oci8))
#1 /var/www/html/medical_draw/adodb5/drivers/adodb-oci8.inc.php(756): ADOConnection->_Execute('UPDATE YC_NPV_N...', Array)
#2 /var/www/html/medical_draw/adodb5/adodb.inc.php(2078): ADODB_oci8->UpdateBlob('YC_NPV_NOTEBA', 'xl_text', '{"nm_patient":"...', 'id_formseq=1234...', 'CLOB')
#3 /var/www/html/medical_draw/php/ws/noteSave.php(89): ADOConnection->UpdateClob('YC_NPV_NOTEBA', 'xl_text', '{"nm_patient":"...', 'id_formseq=1234...')
#4 {main}

"

登入發表討論