Status/Resolution/Reason: Closed/Withdrawn/CannotReproduce
Reporter/Name(from Bugbase): Ying Gao / Ying Gao (cfcary)
Created: 12/05/2014
Components: Database
Versions: 11.0
Failure Type: Non Functioning
Found In Build/Fixed In Build: CF11_Final /
Priority/Frequency: Critical / All users will encounter
Locale/System: English / Win 2008 Server R2 64 bit
Vote Count: 0
Problem Description: Any query that selects a BFILE column from a table in Oracle database (11gR1), the query hangs and returns no result.
Steps to Reproduce:
1. create a test table in a oracle database (11gR1) with a bfile column in it. Upload a test document into the table.
2. Write a query in a ColdFusion page:
test.cfm:
<cfquery>
select bfile_column
from test_table
where rec_id = XXX
</cfquery>
3. Open the test.cfm in a browser. The page hangs and cannot be opened.
Actual Result: Query hangs and no result returns
Expected Result: the query should return the document stream. The query works fine under both CF9 and 10.
Any Workarounds: Use oracle DBMS_LOB utilities to retrieve the BFILE documents.
----------------------------- Additional Watson Details -----------------------------
Watson Bug ID: 3863218
External Customer Info:
External Company:
External Customer Name: cfcary
External Customer Email:
External Test Config: My Hardware and Environment details:
win 2008 Server R2 64 bit + IIS 7 + Oracle 11gR1Attachments:
Comments: