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"



When I try to execute sql query from delphi7 it throws the following exception ORA-01704: string l..

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

Post New Answer

More Delphi Interview Questions

Explain the findnext method?

0 Answers  


How to capture an image from a video source?

0 Answers  


How to Set custom tabstops in a ListBox?

0 Answers  


How to Detect what direction a printer will rotate for a portrait ?

0 Answers  


How to Detect how many jobs are in the print spooler?

0 Answers  






Where is TReport in Delphi 6?

0 Answers  


How to detect the full path or filename of a DLL?

1 Answers  


How to Display a file's associated icon?

0 Answers   HCL,


What if I do not have a CD-ROM drive?

0 Answers  


How to Clear the recent Documents from the Start Menu?

0 Answers  


How many tables can be connected with joins in oracle at a time?

0 Answers  


How to run executables created in Kylix?

0 Answers  


Categories