Home » SQL & PL/SQL » Client Tools » Debug (Oracle 10g)
Debug [message #552156] Tue, 24 April 2012 00:47 Go to next message
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 #552162 is a reply to message #552156] Tue, 24 April 2012 01:06 Go to previous messageGo to next message
Michel Cadot
Messages: 65844
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you think a doctor can diagnose a patient without seeing him?

Regards
Michel
Re: Debug [message #552196 is a reply to message #552156] Tue, 24 April 2012 04:47 Go to previous messageGo to next message
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 Go to previous message
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

Previous Topic: sqlplus : multiple scripts in argument (batch execution)
Next Topic: problem in toad
Goto Forum:
  


Current Time: Wed Oct 17 22:18:07 CDT 2018