We have an application that does masses of inserts. ( Not that I think this is relevant).
The program worked fine on Oracle 9i. I've just changed it over a new db working on Oracle 10G. The application throws an error after its done about 40 inserts with the following error message;
ORA-01480:trailing null missing from STR bind value.
Several other inserts have already passed through this query with no problems.
I had a search on the forum and about the only think I could find was to turn BytesPerCharacter to Auto which I've done.
I installed the DB myself, with all default settings, so its entirely possible that somethings not configured correctly.
Anyone any ideas ??
Dave.
The program worked fine on Oracle 9i. I've just changed it over a new db working on Oracle 10G. The application throws an error after its done about 40 inserts with the following error message;
ORA-01480:trailing null missing from STR bind value.
Several other inserts have already passed through this query with no problems.
I had a search on the forum and about the only think I could find was to turn BytesPerCharacter to Auto which I've done.
I installed the DB myself, with all default settings, so its entirely possible that somethings not configured correctly.
Anyone any ideas ??
Dave.
