Recent content by DavidH

My NLS_LANG must be correct as all "ORA-xxxxx" messages are in Swedish. I just had a look at the topic "Direct Oracle Access Message Translation" which talked about some strings related to TOracleDataSet and TOracleLogon, but there seem to be more strings than that. The two strings I've...

There is a "Date format" property associated with the column. Then you can do something like: with columns[foo] do SetData(formatDateTime(DateFormat,bar)); (where "foo" is the column and "bar" is the date)

Are error messages (such as "Not logged on" etc) in DOA put as resourcestrings? Can I do like I do with the normal Delphi messages (I have translated consts.pas and sysconsts.pas)? Or is there another method to translate the messages?

This is expected behaviour according to Oracle documentation, which says that you're not guaranteed to see every intermediate value.

I'm not sure, but you could try having the field as CLOB when you have character data in it.

somis, I have disabled constraints and such. To set a value in the DirectPathLoader you have to use the column procedure "SetData". I tried not to call SetData for the row/column I wanted to set to null, but that gave me an error upon load ("Invalid date format", as it was a date field).

Could also say that it is an TOracleEvent that receives this message.

Two questions about the TDirectPathLoader: 1) Is it possible to insert nulls in some of the columns (which columns are null depends on which row it is, so I can't exclude the column in the column list), and if it is possible, how do I do it? 2) When can I free the memory I put as a parameter...

I'm using alerts and have the same "problem". // David

If you're just going to do such a simple loop, it might be easier just to write a PL/SQL procedure (try DBMS_LOB.COPY).

ORA-06502: Fel i tal eller v

Is it possible to have a DOA session on a form, without a proper OCI installed? (As long as you do not set the connected property to true, of course.) Maybe I can even detect if OCI is available or not?

Anyway, you may wonder about this starting and stopping. Actually, I have several alerts to wait for, and which ones varies over time. But having seen the monitor over what's going to the server, I realize there is a possibility to lose signals since they are unregistered and then registered...

Hey Marco! This might be a multithread error as well... I realized that the delay between Start and Stop was very small (and OracleMonitor made the delay larger). Start does not actually start the waiting since the waiting is initiated by the thread, which isn't executed until later on. When I...

Hello. To see the 5:th row, do Query.Next four times. If you want to jump back and forth in a Query, you have to use the dataset component instead.