Hi All,
I have a simple PX job as follows:
Seq File ---> Remove Duplicate ---> Oracle EE stage
The write method is UPSERT. I'm running this job from SOLARIS and AIX connecting to same Oracle 10G database using 10G 32 bit client library.
On both DataStage server I'm using 10G sheared object.
The jobs runs fine on SOLARIS server but on AIX it generates a Fatal ORA-01003 Error. The error message is Open failed for insert: esql complaint: ORA-01003: no statement parsed
Would appreciate if somebody would know the reason and help me to solve this problem.
Regards,
Shekhar
ORA-01003 Error
Moderators: chulett, rschirm, roy
ORA-01003 Error
Assume everything I say or do is positive
I have never encountered that error before. But doing a google on the oracle error code returned me this
ORA-01003: no statement parsed
Cause: A host language program call referenced a cursor with no associated parsed SQL statement. A SQL call (for example, OSQL3) must be used to pass a SQL statement to Oracle and to associate the statement with an open cursor. A cursor must already have an associated SQL statement if referenced in any of the following calls: DESCRIBE, NAME, DEFINE, BIND, EXECUTE, and FETCH.
Action: Do the SQL call, for example, OSQL, to pass the required SQL statement before referencing the cursor.
That is the best i can do. Maybe some one else can jump in and help specify the problem.
Regards,
ORA-01003: no statement parsed
Cause: A host language program call referenced a cursor with no associated parsed SQL statement. A SQL call (for example, OSQL3) must be used to pass a SQL statement to Oracle and to associate the statement with an open cursor. A cursor must already have an associated SQL statement if referenced in any of the following calls: DESCRIBE, NAME, DEFINE, BIND, EXECUTE, and FETCH.
Action: Do the SQL call, for example, OSQL, to pass the required SQL statement before referencing the cursor.
That is the best i can do. Maybe some one else can jump in and help specify the problem.
Regards,
Last edited by DSguru2B on Thu May 25, 2006 3:06 pm, edited 1 time in total.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Thanks for your reply.seanc217 wrote:I'm no expert on AIX, but it sound like a reference to a library or something is missing. Check your environment variables maybe?
I would not think of having any problem with environment variables because SELECT and more importantly LOAD is working fine. It is only with the jobs which is having INSERT/UPDATE that is having this problem.
Assume everything I say or do is positive
-
- Premium Member
- Posts: 5
- Joined: Tue Oct 09, 2007 6:29 am
- Location: Chennai
Dear all,
I am facing the same issue. My Environment is AIX and Oracle 10g DB. I am getting this error when I try to insert the data using UPSERT in Oracle Enterprise Stage. The Error what I am getting is ORA-01003 ERROR. It will be better if you could suggest me a solution for it.
Thanks & Regards,
Krishnakumar.B
I am facing the same issue. My Environment is AIX and Oracle 10g DB. I am getting this error when I try to insert the data using UPSERT in Oracle Enterprise Stage. The Error what I am getting is ORA-01003 ERROR. It will be better if you could suggest me a solution for it.
Thanks & Regards,
Krishnakumar.B
Krishna Kumar Bhaskaran
-
- Premium Member
- Posts: 5
- Joined: Tue Oct 09, 2007 6:29 am
- Location: Chennai