When I try to execute sql query from delphi7 it throws the
following exception ORA-01704: string literal too long. I
know the reason why its throwing this exception. My problem
is.... I have catched this exception throw Try.... Except
block.....In except block i am performing rollback..... due
to above error its also throwing exception in rollback
transaction...........due to rollback
exception...........it had created some problem in
connection...........every time when i try to open or close
a connection it throws an exception " Operation is not
allowed when the object is open"

Answer Posted / tazeem ansari

Whenever open an connection database fisrt close it
fist line of code is close connection.

or your database table is open close it from database .

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to Limit the amount of text entered in a TEdit?

1261


How to use far pointers?

1619


How to add system menu items to a form ?

1338


How to capture the current cursor icon and draw it?

1679


How to create a bitmap from an icon?

1286






How to Log in to the remote datamodule?

1540


How to connect to an InterBase database using the BDE API?

1468


How to prevent closing of an undocked ToolBar?

1395


How to Set custom tabstops in a ListBox?

1523


'Translate error, value out of bounds' error what does these errors mean?

2292


How to Get a list of valid time zones from windows?

1930


How to avoid "Random" Exceptions being raised when using TJPEGImage or the JPEG unit?

1263


I am trying to call from Delphi and it GPFs. Whats up?

521


Hi is there is any tool to debug Delphi ISAPI dlls in borland 2006 framework. AS i am a new to delphi borland i need a detailed description for debugging the web application in delphi as per my analysis the ISAPI dlls calling the htm files please help me ....

1825


How to Add TrueType fonts to windows in code?

1267