Recent content by mhajduk

The problem is that the program does setComplexVariable. The program works with oracle 8i but not with 10g. It is the same code with the same oracle tables during our tests. Could it be a problem in the setcomplexvariable.

the error message is as follows: LOB variable :BULKYEFFECTS cannot be nil there is not error number and if provided when the the query execute statement is executed and only if we use 4 lob variables.

on oracle query, if you have a table with 4 blob fields and you insert a record using the insert command with empty_blob() as the value for each blob and using the return function, oracle returns the error "blob can not be empty". This only happens on a table with more that 3 blob fields and...

Good news I have delphi 6 ver 3.4 and dephi 5 ver 3.3. What do I need to do to get both upgraded to 4.0 asap. Registered company is Global Biometrics inc.

I have installed a fresh client and same problem. This is Oracle 10.2 and the version of delphi is 5 with your version of DOA at 3.3.1. Do I need to upgrade your tools. Still get access violation in oracommmon.dll when doing a insert command with a clob write back.

Using delphi 6 with oracle 8i to insert clobs and it works fine. If I attach to a 10g oracle get oracommmon.dll access violations when i try and insert clobs. Adds records without clobs just fine. What is needed to fix this problem. Thanks Mike

Thanks I have solved the problem, I had to insert with empty_clob() for the value before I assigned the value to the locator.

Thanks, I have added the Tloblocator process to the insert but the clob data is always blank. In the example you use a stored procedure. Do you have to have the stored procedure or can you just execute the query and add the data to the clob throught the Tloblocator.

Tying to set a paradox memo field to a CLOB field and having troubles. when inserting a new row assigning the value using; oraclequery.setvariable('Notes',paradoxtable.fieldbyname('notes').value); get error exception Pass Longint(object) to complex variable 'NOTES'. How to you set the clob...

You can go into the registry and create a new string variable called NLS_DATE_FORMAT under the HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ORACLEHOME. Oracle home being your oracle home name on your workstation. Set the string to your date format and oracle will use that date format for all dates on...

I was, thanks for the help M Hajduk

I was, thanks for the help M Hajduk

error in above code the lines that say if firstline then should be if not firstline then MHajduk

CREATE TABLE SYSTEM.MUGBLOB ( RECORDID NUMBER(10, 0), RECORDLINK NUMBER(*), MAINLINK NUMBER(*), IMAGEORDER NUMBER(*), IMAGENUMBER NUMBER(*), DATETAKEN DATE, TIMETAKEN DATE, FPDATE DATE, AFISNUMBER VARCHAR2(30), FPSNUMBER VARCHAR2(30), PICREG VARCHAR2(30), FPREG...

here is a quick and dirty way without using parm lists and lets you send any of the three. could be syntax errors did it quickly. I hope this gives you some ideas. ----------------------- function GetResult(sItemDesc, sItemCodeChar: string; iCompCode: integer): boolean; var firstline:boolean...