User-Defined Exception in arp_auto_rule .create_distributions [message #409583] |
Tue, 23 June 2009 03:44 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
rak007
Messages: 107 Registered: October 2006 Location: Mumbai / Pune, India
|
Senior Member |
|
|
I am using the following code snippet in a report(without anonymous block ofcourse)
declare
lines number;
begin
dbms_output.put_line('lines value before: ' || lines);
lines := arp_auto_rule.create_distributions( :p_commit_at_end ,:p_debug_flag ,NULL ,'N' ,'N' );
dbms_output.put_line('lines value after: ' || lines);
exception
when others then
dbms_output.put_line('Error is: ' || SQLERRM);
end;
Here 'lines' is defined as a number as the function return a number.
Now if i run this in a anonymous block with the first two values as 'N' it runs fine and gives the following output
lines value before:
lines value after: 0
Now if i used the same API call in report i get the following error
lines value before:
Error is: User-Defined Exception
|
|
|
Re: User-Defined Exception in arp_auto_rule .create_distributions [message #409588 is a reply to message #409583] |
Tue, 23 June 2009 03:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Next time you post code can you format it properly so it's not five screens wide please.
arp_auto_rule.create_distributions is rasing an exception.
Without knowing what code it contains I really can't say any more except you should check all the parameter values being passed by the report to see if they are what you think they are.
|
|
|
|
|