M9 1a8 8 0 1 0 1 objcommand.execute(query) 16A8 8 0 0 0 9 1zm. M9 1a8 8 0 1 0 0 16A8 8 0 0 0 9 1zM8 15. LOGIN_NAME from TABLE_CASE, TABLE_USER, TABLE_PRIVCLASS, TABLE_CONDITION, TABLE_PART_NUM where TABLE_CASE.
This code also works perfectly although vulnerable to SQL injection. ID_NUMBER from TABLE_CASE, TABLE_USER, TABLE_PRIVCLASS, TABLE_CONDITION, TABLE_PART_NUM where TABLE_CASE. I did not realize that ‘text’ wasn’t a true type. ID_NUMBER from TABLE_CASE, TABLE_USER, TABLE_CONDITION, TABLE_PART_NUM where TABLE_CASE. I took out the ‘family’ variable and just replaced it with one of the families I’m looking for and it ran as expected. It may be worth trying the same family in both approaches, in case the problem depends on the records that are being found by the query. Oracle often performs implicit casts that work for some values but not others.
What is the exact DDL SQL type for TABLE_PART_NUM. Also, please note that by default NVARCHAR2 size is in characters but VARCHAR2 is in bytes – maybe “4000” in your code is interpreted as 4000 characters, exceeding the maximal field width for character data of 4000 bytes. Try using 2000 or even lower number just for testing purposes. Try to execute the query from the SQL Developer. Do you have any problems there? Do you use any “unusual” character encoding in your database? NLS_CHARACTERSET for VARCHAR2 encoding and NLS_NCHAR_CHARACTERSET for NVARCHAR2 encoding.
Do you get this problem if you try using the equivalent ODP. I have tried your suggestion without luck. You say you tried it “without luck” – does that mean you got the same exception? Yes, still getting the same exception when I change to: TABLE_CASE. Thanks for all the help the date seems to be OK. I tried the same query but put in a static value for family and it works. Has to be something with the family one but I don’t know what.