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 Copy contents of a control to the clipboard?
Where is "View | Project Source" ?
How to tell if a form has been created (or any object)?
How to Implement the VB TwipsPerPixel in Delphi ?
How to Display a bitmap on the client area of an MDI parent form?
How to turn off ISAPI DLL caching on Windows 2000 and IIS5 ?
How to Save and load metafiles in a BLOB field without using DBImage ?
How to create SQL queries with SQL Builder?
How to Get the windows directory?
How to Clear the recent Documents from the Start Menu?
How to Declare a SafeArray in the type library editor?
How to Select a cell in a DBGrid ?