MaintainDelphi
Programmer
I am facing strange database connection problem. I am working with Delphi 6.0 with some third party components for database operations like TOracleSession, TOracleQuery, TOracleDataset.
We are trying to set up same development environment at two different locations. For this we have installed Delphi Code and all the third party copmonents at both the locations. We have also replicated Oracle database schemas at both the locations.
When I log in to the application and point database to the orignal Database server it works perfectly fine.
When same application connects to local database server it connects successfully. But when query is executed... it gives error which says
"ORA - 01460 unimplemented or unreasonable conversion requested"
I never receive this error when I am pointing to orignal database schema. Application works absolutely fine when I am connecting with the orignal database server.
I tried all possible options to sort out the problem for local database installation. Few of the things I had tried and concluded were as follows:-
I found that if more than one varchar Parameters are passed in the SQL query always error occurs when query is executed.
I tried passing only one varchar and one numeric type parameter and query executes successfully without any error.
There are two options for executing the query...
1. defining parameters at component level and passing values to those parameters.
2. building sql string and executing using component without defining parameters at component level.
When I use second option, it executes without any error in the local database.
Please guide me as I have been struggling with this issue since last one week. Any help regarding this will be highly appreciated. Please guide me how can I get rid of this problem.
"ORA - 01460 unimplemented or unreasonable conversion requested"
Please let me know if any more information is required.
Thanks,
Raj
We are trying to set up same development environment at two different locations. For this we have installed Delphi Code and all the third party copmonents at both the locations. We have also replicated Oracle database schemas at both the locations.
When I log in to the application and point database to the orignal Database server it works perfectly fine.
When same application connects to local database server it connects successfully. But when query is executed... it gives error which says
"ORA - 01460 unimplemented or unreasonable conversion requested"
I never receive this error when I am pointing to orignal database schema. Application works absolutely fine when I am connecting with the orignal database server.
I tried all possible options to sort out the problem for local database installation. Few of the things I had tried and concluded were as follows:-
I found that if more than one varchar Parameters are passed in the SQL query always error occurs when query is executed.
I tried passing only one varchar and one numeric type parameter and query executes successfully without any error.
There are two options for executing the query...
1. defining parameters at component level and passing values to those parameters.
2. building sql string and executing using component without defining parameters at component level.
When I use second option, it executes without any error in the local database.
Please guide me as I have been struggling with this issue since last one week. Any help regarding this will be highly appreciated. Please guide me how can I get rid of this problem.
"ORA - 01460 unimplemented or unreasonable conversion requested"
Please let me know if any more information is required.
Thanks,
Raj