Oracle Error in view data
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Oracle Error in view data
Hi,
I have job with oracle connector stage,job is running fine but when i am doing view data it gives me below error message:-
The OCI function OCIStmtExecute return status -1. Error Code:3,115,Error Messgae: ORA-03115:unsupported network datatype or representation.
Can anyone faced the same issue.Please help me out to resolve this.
I have job with oracle connector stage,job is running fine but when i am doing view data it gives me below error message:-
The OCI function OCIStmtExecute return status -1. Error Code:3,115,Error Messgae: ORA-03115:unsupported network datatype or representation.
Can anyone faced the same issue.Please help me out to resolve this.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
I tried to investigate more further and found that when query has functions like NVL it gives me error in viewing data.
For e.g.
When i paste below query in oracle connector,i am able to view the data.
But with below query i am getting error .
I am unable to firgure out what is the issue.
I tried to investigate more further and found that when query has functions like NVL it gives me error in viewing data.
For e.g.
When i paste below query in oracle connector,i am able to view the data.
Code: Select all
SELECT /*+ PARALLEL(a,4) */
ITEM,
BUSINESS_UNIT_ID,
DEPT,
CLASS
FROM
#Source_DB.SRC_SCHEMA#.#SRC_TABLE_NAME# a
Code: Select all
SELECT /*+ PARALLEL(a,4) */
ITEM,
BUSINESS_UNIT_ID,
DEPT,
CLASS,
NVL(LOC,'-1111') AS LOC_NEW
FROM
#Source_DB.SRC_SCHEMA#.#SRC_TABLE_NAME# a
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
I have changed the name as "LOC" and in metadata it is also "LOC" but still i am getting same error
I have changed the name as "LOC" and in metadata it is also "LOC" but still i am getting same error
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Have you asked your DBA? Or your support provider? I've only seen mention of that error when hitting an 8i instance and typically that over a dblink, I'm guessing neither of those are the case here so it could be a bug in the stage or perhaps in the Oracle client.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers