ORA 10306 - Illegal parametrer/number error

hemant · Post by **hemant** » Thu Oct 06, 2005 8:46 am

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

ArndW · Post by **ArndW** » Thu Oct 06, 2005 9:02 am

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?

chulett · Post by **chulett** » Thu Oct 06, 2005 9:05 am

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.

kcbland · Post by **kcbland** » Thu Oct 06, 2005 9:37 am

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.