Recent content by ChristofK

Thanks for the info! Christof Kihm

Hello Marco, thanks a lot for your hint, now it works well. By the way: I told the Package Wizard to prefix database objects with schema name. Except the line after "declare" OCPQuery.SQL.Add('declare'); OCPQuery.SQL.Add(' function_result "TRACE_SU"."PKG_TRACE_T_CTL_L3".t_ctldata;'); the...

Hi Marco, adding the user brings no change. I tested as well the following function, which brings the same error as described: try if rbDB01.Checked then OracleSession1.LogonDatabase := edtDB01.Text else if rbDB02.Checked then OracleSession1.LogonDatabase := edtDB02.Text...

This is the Record: TYPE t_ctldata01 IS RECORD ( ctlstr VARCHAR2 (200), artno01 trace_su.t_sn01.artno01%TYPE, orderno trace_su.t_sn01.orderno%TYPE ); This is the function...

... and the problem was gone! thanks!

Hi, compiling the following line OracleDataSet02.DeclareVariable('DMC', otInteger); ends in an error: [Fehler] UnitQuery01.pas(51): Undefinierter Bezeichner: 'otInteger' but OracleData is mentioned in the uses area. When not in OracleData, where's the declaration of the ot???? identifiers...

Thanks a lot, the expression (Connected and (CheckConnection(False) = ccOK)) works without provoking an exception as the expression if(connected=True) does when the network connection was interrupted.

Thanks a lot for Your reply! You say: 'because the TOracleSession does get a signal that this has happened.' my question: How can I detect the status of TOracleSession. Is the combination of - CheckConnection and - if (Connected = True) the answer? Thanks in advance!

Hi, during a database session, I get an exception E:EOracleError when I disconnect my computer from the network. Thats OK. During the exception handling, I use the command session.connected:=false with result of another exception. not using this command, outside of the exception handling the...