Hi Naveen,
If you wan to try with the second option, then do follow the below steps.
By default the Object Spy only shows Oracle recognition against Oracle Test Object when the add-in is enabled, so either of the following can be done to get Java recognition instead of Oracle temporarily:
1.Re-launch QTP with only Java and Web Add-ins
2.Backup the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Mercury Interactive\JavaAgent\Oracle Add-in for QuickTest\Enabled, then set its value to zero (0) and restart QTP with Oracle and Web add-ins.
The backup is to return to previous settings/functionality when needed.
The status bar can sometimes show a syntax such as “Record: 1/?” where the question mark (“?”) is indicating Oracle hasn’t calculated or analyzed the table completely, therefore not determining how many rows or records are on the table. This requires forcing Oracle to analyze the displayed table and find the last record to change the question mark (?) for the real number representing the last record or row of it.
It’s possible to force Oracle to find that last record of the table via its own menu options:
1.Open the Oracle application menu called “View”
2.Navigate the menu until “Record” is found
3.Within the displayed sub-items of “Record”, select “Last”
4.Oracle will display a “Process” dialog window indicating “Retrieving next 100 records”.
5.If the amount of rows goes higher than the mentioned 100 records, then a “Decision” dialog window will appear and in order to get to last record, selecting “Continue to End”.
If QTP is used to automate these steps, then something similar to the following code could result:
If you wan to try with the second option, then do follow the below steps.
By default the Object Spy only shows Oracle recognition against Oracle Test Object when the add-in is enabled, so either of the following can be done to get Java recognition instead of Oracle temporarily:
1.Re-launch QTP with only Java and Web Add-ins
2.Backup the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Mercury Interactive\JavaAgent\Oracle Add-in for QuickTest\Enabled, then set its value to zero (0) and restart QTP with Oracle and Web add-ins.
The backup is to return to previous settings/functionality when needed.
The status bar can sometimes show a syntax such as “Record: 1/?” where the question mark (“?”) is indicating Oracle hasn’t calculated or analyzed the table completely, therefore not determining how many rows or records are on the table. This requires forcing Oracle to analyze the displayed table and find the last record to change the question mark (?) for the real number representing the last record or row of it.
It’s possible to force Oracle to find that last record of the table via its own menu options:
1.Open the Oracle application menu called “View”
2.Navigate the menu until “Record” is found
3.Within the displayed sub-items of “Record”, select “Last”
4.Oracle will display a “Process” dialog window indicating “Retrieving next 100 records”.
5.If the amount of rows goes higher than the mentioned 100 records, then a “Decision” dialog window will appear and in order to get to last record, selecting “Continue to End”.
If QTP is used to automate these steps, then something similar to the following code could result:
Code:
OracleFormWindow("...").SelectMenu "View->Record->Last"
If OracleNotification("Decision").Exist Then
OracleNotification("Decision").Choose "Continue to End"
End if