| Debug [message #552156] |
Tue, 24 April 2012 00:47  |
b_chugh
Messages: 68
Registered: August 2005
Location: delhi
|
Member |
|
|
Hi All
I want to debug a function which returns the table of records. When I try to add the parameters and run the debug it gives the error as
PLS-00653: aggregate/table functions are not allowed in PL/SQL scope
Please let me know if there is any way to debug the function which returns table of records.
Thanks
b_chugh
|
|
|
|
|
|
| Re: Debug [message #552196 is a reply to message #552156] |
Tue, 24 April 2012 04:47  |
b_chugh
Messages: 68
Registered: August 2005
Location: delhi
|
Member |
|
|
Hi All
Please find the attached txt file which has the test package spec package body and the script used to run/debug the packaged function. I am using the TOAD tool to debug the function.
Regards
b_chugh
|
|
|
|
| Re: Debug [message #552859 is a reply to message #552196] |
Sun, 29 April 2012 13:08 |
 |
deepakkrjain3
Messages: 8
Registered: October 2011
Location: Delhi
|
Junior Member |
|
|
hi, have you ever been compile your package. I think no....
Because I found lot of mistakes in your package... any way find attached package and try to debugging.
Note:- change your parameter data type... for checking i have done some changes.
Best Regards,
Deepak
[Updated on: Sun, 29 April 2012 13:12] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
