Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

[nQSError: 17012] Bulk fetch failed. (HY000)

user11049754Aug 25 2009 — edited Aug 26 2009

Hello All,

I am getting the following error when trying to access org_code from 2 different tables (these 2 tables comes from 2 different scemas) from the same subject area ProjectReport_PC.

View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 17001] Oracle Error code: 1722, message: ORA-01722: invalid number at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. (HY000)
SQL Issued: SELECT PROJECTDATA.ORG_CODE saw_0, REF_ORGANIZATIONS.ORG_CODE saw_1 FROM ProjectReport_PC ORDER BY saw_0, saw_1

Any help is appreciated.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 23 2009

Added on Aug 25 2009

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

5 comments

9,615 views