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 / 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 |
How to Set default value for decimal places in the BDE?
How to use sets in code, such as adding to TDBGrid.Options, at run time?
How to move Client Objects to a different AS/400?
How to use the InterBase API security functions to add, modify and delete users?
How does one change the default directory that Delphi uses to save projects?
How to Connect to a remote CORBA server?
How to create an executible file using the command line directive in Linux with Kylix?
How to Determine if an object supports a property?
How to get Table data subset through IProvider ?
How to Set the MaxPage property of the PrintDialog component?
How to Extract RGB components of a color?
How to Get property information ?