oracle.dmt.odm.InvalidArgumentException : Invalid length for argument "Schema". It must contain between 1 and 32 characters.
I get this error when I run any of the sample ODM code.
The code appears to have a problem with the LocationAccessData object, it takes two parameters table_name and schema_name and it complains that the schema_name is not between 1 and 32 characters.
I have an Oracle 9.2.0.1 database patches with P2498603, P2632931 and P2647739, all patches installed successfully.
The oracle database runs on Windows NT and Windows 2000 server and I get this error on both windows platforms.
I am running java j2sdk 1.4.0_04 and j2sdkee 1.3.1
What I've tried :
I put some debugging into the java code and it does output ODM_MTR as the schema. I hard coded ODM_MTR as the schema rather than passing it in as a variable but no good.
I checked the logs and went through the two ODM patches line by line and it does load the LocationAccessData class via odmapi.jar okay.
I have tried it with various combinations of the three patches but I get the same error.
I downloaded dm4j from the otn website, installed it, went through the wizard and created java code. When I run the java code, I get the same error. dm4j has its own odmapi jar file but that still does not get me around this issue.
I've tried the web, forums, whitepapers and nothing lists this as a problem.
Does anyone know of any way around this issue