Hi all,
one of our developers has written some code in PL/SQL. When the code is run in PL/SQL, it returns the correct results:
| TX Time |
On Date |
Program Name |
Episode Name and Number |
Slot Duration |
test |
| 7:40 |
03/04/2010 |
Ray Mears' Extreme Survival (2) *84 are signed* |
Ray Mears: Extreme Survival (2): Ep 1, Sahara |
0.67 |
60000 |
| 8:20 |
03/04/2010 |
Ray Mears' Extreme Survival (2) *84 are signed* |
Ray Mears: Extreme Survival (2): Ep 2, Rockies, The |
0.67 |
60000 |
| 12:30 |
03/04/2010 |
Ray Mears' Extreme Survival (2) *84 are signed* |
Ray Mears: Extreme Survival (2): Ep 2, Rockies, The |
0.5 |
45000 |
| 12:00 |
03/04/2010 |
Ray Mears' Extreme Survival (2) *84 are signed* |
Ray Mears: Extreme Survival (2): Ep 1, Sahara |
0.5 |
45000 |
As it is supposed to return only results where the figures under the "Test" column are greater than 0 (zero).
When the same code is run via Crystal, the results are displaying 3 extra rows for which PL/SQL was correctly not reporting as the "test" value is supposed to be 0 :
| TX Time |
On Date |
Program Name |
Episode Name and Number |
Slot Duration |
test |
| 7:40 |
03/04/2010 |
Ray Mears' Extreme Survival (2) *84 are signed* |
Ray Mears: Extreme Survival (2): Ep 1, Sahara |
0.67 |
60000 |
| 8:20 |
03/04/2010 |
Ray Mears' Extreme Survival (2) *84 are signed* |
Ray Mears: Extreme Survival (2): Ep 2, Rockies, The |
0.67 |
60000 |
| 12:30 |
03/04/2010 |
Ray Mears' Extreme Survival (2) *84 are signed* |
Ray Mears: Extreme Survival (2): Ep 2, Rockies, The |
0.5 |
45000 |
| 12:00 |
03/04/2010 |
Ray Mears' Extreme Survival (2) *84 are signed* |
Ray Mears: Extreme Survival (2): Ep 1, Sahara |
0.5 |
45000 |
| 7:00 |
03/04/2010 |
Extreme Lives (1) |
Lord Of The Skies |
0.67 |
60000 |
| 14:00 |
03/04/2010 |
Have I Got News For You (21) |
Have I Got News For You (21): Ep 6 *84 is PRE*# |
0.67 |
60000 |
| 19:00 |
03/04/2010 |
Have I Got News For You (21) |
Have I Got News For You (21): Ep 6 *84 is PRE*# |
0.67 |
60000 |
We are running Oracle 9i and version 9 of Crystal...I have tried to redo synonims and change cursors...but it still does not work...it seems that Crystal translates the results from PL/SQL in a different way...
Can you help?
Thanks
IP Logged