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

Explain the findnext method?

468


How to Convert ASCII files to Paradox tables?

1526


'General SQL Error : Connection does not exist' in threaded application . what does this indicates?

1573


Why can't we display data in descending order in Delphi?

1225


How to Typecaste a PChar to a longint?

1242






How to convert a .dfm file to text and vise versa?

1299


Is it possible to connect to InterBase from a Delphi app without using the BDE?

1308


How to create an About Box in Delphi or C++ Builder?

2132


How to Determine if a combobox is in dropped state?

1340


What you can contribute to the IBM?.

1870


What is the function of dynamic arrays?

435


How to Get property information ?

1443


How to close your application using the Escape key?

1282


How to assign a file variable in a Record?

1353


What does memory leak show in delphi?

436