I am executing a query in TOAD which works fine. It takes 15 minutes to retun the data.
Now, when I execute the same query using db_execute_query function in Winrunner it returns the error : -10162
E_SQL_SYNTAX_ERROR -10162 Syntax error in the SQL statement.
The reason for this failure I think is that Winrunner is not waiting till the time the data can be retrieved from the database. In my case it is 15 minutes.
So please if someone can help me with either how to increase the wait time in the Winrunner setttings or is there any other reason because of which the SQL query is failing.
Any suggestions on this would be highly appreciated.
Thanking you in anticipation
Can you post the SQL query here??? You can change the default timeout settings in Tools -> General Options, but this would affect all your other statements as well.
-10162 isn't related to the time the SQL query is taking, it means exactly what it says - you have misconstructed your SQL query in the WR command.
Make sure you are using the correct building of any strings with apostrophes or quotes in what you are using. That is usually the biggest issue with the commands.
And as stated, posting the query would be beneficial for anyone to actually volunteer any assistance.
Insanity: doing the same thing over and over again and expecting different results