Recent content by nwgarside

Hi Marco, Thanks for the prompt response. Okay...I will try using a TOracleQuery as you suggest. One related question I was hoping you could respond to...using the same TOracleScript as in my original post, I am getting a count of commands in the script, and then running each command...

Hello, I'm using DOA 4.0.7.1 with Delphi 2007 on Windows 7 x64. I'm using a TOracleScript component to execute a script containing both DML and DDL commands such as the following: -- Name = "type_dml Disabling triggers" SELECT 'ALTER TABLE '||LOWER(table_name)||' DISABLE ALL TRIGGERS;' FROM...

Thanks Marco. That worked a treat! Why does the ORA-02248 error occur in DOA? If I save the original code as a SQL script it can be run successfully in SQL*Plus. Thanks again! /Neil

Hello! I'm using DOA 4.0.7.1 with Delphi 2007 on a Windows 7 x64 laptop and version 11.2.0.1.0 of the 32-bit Oracle Instant Client. I've added a TOracleQuery with the following SQL: ALTER SESSION SET smtp_out_server = '<my_smtp_server>' BEGIN utl_mail.send( sender => '<sender>'...

Hi Marco, A-ha! I just tried specifying the variables' value in the default Windows short date format 'DD-MM-YYYY', (e.g., '15-11-2007') and the 'Error converting values' error did not occur! I'm sure I tried that format before my original posting! Anyhow, it's now fixed. Thanks for your...

Hi Marco, Thanks again for the prompt reply. In my Control Panel > Regional and Language Options I have the following settings: Short Date Format: dd-MMM-yyyy (sample: 15-Nov-2007) Long Date Format: dddd dd MMMM yyyy (sample: Thursday 15 November 2007) I've tried putting both sample values...

Hi Marco, Thanks for the prompt reply. I'm aware of the SetVariable procedure, but I'm wanting to set the variables' value at design-time (so the dataset can be made active at design-time). So, how do I set the variables' value using DOA's Variables Editor window at design-time? Kind regards...

I'm using DOA 4.0.7.1 with CodeGear Delphi 2007 for Win32 (v11.0.2804.9245). My TOracleDataSet's SQL looks like this: SELECT * FROM refunds_mv WHERE loginfo_insdate BETWEEN TRUNC(:p_range_start) AND TRUNC(:p_range_end) ORDER BY loginfo_insdate ASC The loginfo_insdate column is datatype DATE...

That might make sense - I'm using the Oracle Instant Client on the laptop; prior to the rebuild I had the full Oracle9i client installed. I'll reinstall the Oracle9i client and see if that resolves the issue. Kind regards, Neil W. Garside

I have recently re-formatted my laptop and re-installed Windows XP Pro SP2, Delphi 6.0 Pro (with Update Pack 2) and DOA 4.0.7.1. When I open a Delphi project I developed before reformatting the laptop, and run it within the IDE, Delphi's CPU window appears when the TOracleSession's Logon method...

Using Delphi 6 Pro (SP2), Oracle 8.1.7, DOA v3.4.6.1. My TOracleQuery's SQL is as follows: BEGIN SELECT col1 INTO Col1 FROM my_table WHERE...; SELECT col2 INTO Col2 FROM my_table@NCAP WHERE...; END; The query works fine and takes 4-5 seconds retrieving the two values (NCAP is a database...

Thanks Marco. You are absolutely right. It's a long story but to sum up, after I'd rebuilt the Employees table with the LONG RAW column none of the picture fields were populated, hence I was getting errors originating from the JPEG unit when I tried the 'Assign' command. I mistakenly thought the...

Hi Everyone, I have an Employee table which contains a LONG RAW column with a small (