在oracle 11g中选择clob字段时出现500错误(500 error when select clob field in oracle 11g)

 当我运行我的oracle查询显示服务器中的500错误。 在oracle查询中选择clob字段时显示的错误。该字段包含大的json数据 
 
 错误是： 
 
 
 
 HTTP错误500.0 - 内部服务器错误C：\ php7.0.3 \ php-cgi.exe - FastCGI进程意外退出 
 
 
 在这里我的查询： 
 
SELECT knowyour.*,
  kp.personal_details AS personal_details,
  kp.fullname,
  kcd.category,
  kcd.ID AS kycID
FROM
  (SELECT DISTINCT kc.kyc_reffer_id,
    kc.ID,
    kc.customer_id,
    kc.json_details AS json_details,
    kc.customer_joint_id,
    kc.customer_id AS kycCustomer_id
  FROM db.knwcustomer kc
  ) knowyour
INNER JOIN db.createdetails kcd
ON (knowyour.customer_id=kcd.customer_id)
INNER JOIN db.personaldetails kp
ON (knowyour.kyc_reffer_id=kp.kyc_reffer_id)
LEFT JOIN db.kaccountdetails kd
ON (knowyour.customer_id=kd.customer_id)

WHERE kcd.displayStatus!=:status
AND kcd.category=:category
AND kd.status!=:status
AND kp.status!=:status
AND kcd.client_id=:client_id
ORDER BY kcd.ID
 
 这里status = -1 
 
 （查询在php pdo中运行） 
 
 这是一个示例查询。 
 
 personal_details和json_details是clob fields.Distinct在选择clob字段时不起作用，这就是我使用此查询方法的原因。 
 
 这是代码问题还是服务器问题？ 但是这个代码在我的本地wamp服务器上工作得很好，而不是在在线服务器上。 
 
 我需要帮助 ！ 

When iam running my oracle query showing 500 error in server. The error showing when selecting clob field in oracle query.The field contains big json data
 
Error is: 
 
 
 
HTTP Error 500.0 - Internal Server Error C:\php7.0.3\php-cgi.exe - The FastCGI process exited unexpectedly
 
 
here my query:
 
SELECT knowyour.*,
  kp.personal_details AS personal_details,
  kp.fullname,
  kcd.category,
  kcd.ID AS kycID
FROM
  (SELECT DISTINCT kc.kyc_reffer_id,
    kc.ID,
    kc.customer_id,
    kc.json_details AS json_details,
    kc.customer_joint_id,
    kc.customer_id AS kycCustomer_id
  FROM db.knwcustomer kc
  ) knowyour
INNER JOIN db.createdetails kcd
ON (knowyour.customer_id=kcd.customer_id)
INNER JOIN db.personaldetails kp
ON (knowyour.kyc_reffer_id=kp.kyc_reffer_id)
LEFT JOIN db.kaccountdetails kd
ON (knowyour.customer_id=kd.customer_id)

WHERE kcd.displayStatus!=:status
AND kcd.category=:category
AND kd.status!=:status
AND kp.status!=:status
AND kcd.client_id=:client_id
ORDER BY kcd.ID
 
here status = -1
 
(query running in php pdo)
 
This is an example query.
 
personal_details and json_details are clob fields.Distinct will not work when selecting clob field that's why Iam using this query method.
 
is this code problem or server problem? But this code is working perfectly in my local wamp server not in online server.
 
I need help !

原文：https://stackoverflow.com/questions/37203353