Error:
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 932, message: ORA-00932: inconsistent datatypes: expected - got CLOB at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)
SQL Issued: SELECT 0 s_0, "SPM - Strategic Plan"."Res Statement"."Responsibility Statment Ar" s_1, "SPM - Strategic Plan"."Res Statement"."Responsibility Statment" s_2 FROM "SPM - Strategic Plan"
Solutions:
Create a view in database by selecting all the columns and use this DBMS_LOB.SUBSTR(<Clob column>) for clob column.
example: SELECT rs.sp_id,
CAST(DBMS_LOB.substr(rs.RESPONSIBILITY_STATMENT,4000,1)AS VARCHAR2(4000)) RESPONSIBILITY_STATMENT,
CAST(DBMS_LOB.substr(rs.RESPONSIBILITY_STATMENT_AR,2150,1) AS VARCHAR2(4000)) RESPONSIBILITY_STATMENT_AR,
CAST(DBMS_LOB.substr(rs.RESPONSIBILITY_STATMENT_AR,4000,2151) AS VARCHAR2(4000))
FROM
xxspm_respon_statment rs
If it is English characeter it will accept up to 4000 char , If it is Arabic character it will allow you 2150 characters you can split the data in to two columns like in the example.
1) In the RPD physical layer change the data type to Longvarchar
2) In the report level add two arabic columns using concatinate symbal ( || ) in the expersion builder report will work
good luck.
example: SELECT rs.sp_id,
CAST(DBMS_LOB.substr(rs.RESPONSIBILITY_STATMENT,4000,1)AS VARCHAR2(4000)) RESPONSIBILITY_STATMENT,
CAST(DBMS_LOB.substr(rs.RESPONSIBILITY_STATMENT_AR,2150,1) AS VARCHAR2(4000)) RESPONSIBILITY_STATMENT_AR,
CAST(DBMS_LOB.substr(rs.RESPONSIBILITY_STATMENT_AR,4000,2151) AS VARCHAR2(4000))
FROM
xxspm_respon_statment rs
If it is English characeter it will accept up to 4000 char , If it is Arabic character it will allow you 2150 characters you can split the data in to two columns like in the example.
1) In the RPD physical layer change the data type to Longvarchar
2) In the report level add two arabic columns using concatinate symbal ( || ) in the expersion builder report will work
good luck.
0 comments:
Post a Comment