Recent content by Cybrey

Ignore I'm was jumping the gun. Upgraded to 4.0.5 and the problem went away .. :)

We have an application that does masses of inserts. ( Not that I think this is relevant). The program worked fine on Oracle 9i. I've just changed it over a new db working on Oracle 10G. The application throws an error after its done about 40 inserts with the following error message...

And this will populate the fieldsDefs collection ?

I would like get a list of fields at runtime without opening the dataset. Basically we're using a Stored Procedure wrapped inside TOracleDataset. It returns a ZCursor. In deisgn time if I right click on the fields dialog and click 'add all fields' it adds all the fields. I need to be able to...

Thanks.. the solution works.. with the obvious side effect that the files end with a '\' which the component throws out as an error. I'll write something that strips this out first.. Thanks again for the help. Cybrey

We load oracle stored procedures in the following way.. (after a connection is made). oraclescript1.loadfromfile('c:\temp\aheader.spc'); oraclescript1.execute; I'm trying to load a JSP in the same manner; oraclescript1.loadfromfile('c:\temp\ajsp.jsp'); oraclescript1.execute; The...

I've downloaded it 4 times on my machine and twice on someone elses. The zip file is fine as it doesn't have any CRC's, the problem comes when running the exe. I'm fairly sure the company doesn't use a proxy server. We've also downloaded previous updates. Are there any other locations other...

Sorry I should have said that I'm trying to use the Delphi 5 version of this file.

Thanks for the reply and help. I've tried downloading the file mentioned and I get an error unpacking file message when running the .exe file supplied in the zip file.

'ORA-1460 unimplemented or unreasonable convention requested'. I don't know if this is relevant but we started getting this all over the place, PL/SQL suffers from it as well ( at least the version we have does). The reason that it occurred in our applications was due to the way the user is...

We're getting the usual "can bind a LONG value only for insert into a LONG column" on an execute with a TOracleDataset on a UTF8 database. The code worked perfectly on 8i. The code also works perfectly if the session property UseOCI7 set to true, this isn't really an option. We think the...

The code is amalgatmation of several sources, some of which were from this forum. For instance your code doesn't cover how to use the CLOB on the server side. If it makes you feel any better you can claim that the code is yours as I don't really care. All I was posting was the solution that we...

Ok finally managed to get a solution from an almagmation from several sources.. I'll post here just to show people how we achieved it. ******************** ** PL/ SQL Source ******************** PROCEDURE InitClob( Clobname OUT CLOB)IS BEGIN dbms_lob.CreateTemporary( Clobname, FALSE)...

We're in the process of writing a SQL syntax checker for SQL which passes SQL to a stored procedure. Problem is with strings it runs into a 4000 character limit on PL/SQL. We have got around this using CLOB. Definition of Stored Procedure looks something like this... function testSQL( sqltext...