Hi all,
I'm getting oracle error while running the server job. I have two OCI stages and one is lookup into another.
So far I'm unable to find a solution.
Please let me know if someone faced the same problem and solution for the same.
Regards
Hemant
ORA 10306 - Illegal parametrer/number error
Moderators: chulett, rschirm, roy
hemant,
I don't think that the error message alone is sufficient to diagnose the problem in this case. If you were to take out the lookup does the error go away? Are you using your own SQL or generated SQL? Does the SQL execute if you try to enter it manually in sqlplus or whatever tool you use?
I don't think that the error message alone is sufficient to diagnose the problem in this case. If you were to take out the lookup does the error go away? Are you using your own SQL or generated SQL? Does the SQL execute if you try to enter it manually in sqlplus or whatever tool you use?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
Can't provide specific help without alot more information.
I'm assuming there is custom (user defined) sql involved as that is typically the only way to get this error - and it typically involves a mis-match between the number of columns defined in the Columns tab, the number of fields returned by the sql and your usage of parameter markers. Also which columns are marked as Keys can play a role.
Post your sql and as much detail as possible about exactly what you are doing, then perhaps someone can help.
I'm assuming there is custom (user defined) sql involved as that is typically the only way to get this error - and it typically involves a mis-match between the number of columns defined in the Columns tab, the number of fields returned by the sql and your usage of parameter markers. Also which columns are marked as Keys can play a role.
Post your sql and as much detail as possible about exactly what you are doing, then perhaps someone can help.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
We need to know, did the error happen on the primary input stream OCI stage or the reference stream OCI stage. I'm guessing the reference. If it is the reference, you're probably having an illegal datatype value come thru that doesn't match the datatype of the reference lookup. Just a guess without enough information.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle