Recent content by bit2

I've got the answer to the CharSetID=0. :-) I bet you would never guess it. ;-) Some very analytic mind (Sherlock H.?) would be needed to guess the correct answer without having access to my database. To cut it short: our application had a local "DUAL" table in it's schema. PL/SQL Developer...

Today I ran into the same problem: CharSetID=0 and NCharSetID=0. It happens with a 9iR2 database (9.2.0.1.0 on a Win2003 server) with NLS_CHARACTERSET=AL32UTF8, NLS_NCHAR_CHARACTERSET=AL16UTF16. The database contains a number of schemas/users. I've created a new one, imported some tables into it...

The problem here was not with Sundog's solution, but the "specification" of the task. How do you define "same day"? Do you want to get the same day of the same week in the previous year (at least your answer suggests that)?

Nothing that I could tell. No other user had accessed neither the database, nor the client between the two attempts. On the other hand it would be extremely useful if PLSD notified the user in case it could not determine what characterset is being used (I mean in case CharSetID=0 or...

It seems to me that the "Import Tables" functionality (in "Tools" menu) uses simple INSERTs instead of "bulk" INSERTs. Is there any "bulk" DML functionality in OCI at all or it's available only in PL/SQL?

OK, this is weird. Today on the same PC in the same session (I mean didn't log off or anything) without me having done any changes PLSD reports CharSetID and NCharSetID properly in Support Info. :-o It's driving me crazy. :mad: I really did not touch anything ... I still have two instances of...

I'm using BYTE schemantics in an AL32UTF8 database (nls_length_semantics=BYTE in v$parameter) and experienced ORA-01460 ("unimplemented or unreasonable conversion requested") upon opening tables via right-clicking in object browser and selecting "View" or "Edit". I checked the "Support Info"...

Unfortunately this is still not fixed in v7.1.2.1363. :-(