Home » Developer & Programmer » Reports & Discoverer » Its urgent pelase try to help
Its urgent pelase try to help [message #190336] Wed, 30 August 2006 04:47 Go to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Hi,

I have a report which is taking data from the view and generates the report.

I am using that report to generate the cost sheet for the colliery area. My report is working fine for the 12 areas but for a particular area a function column is returning a errors:

REP-1401 : cf_cptformula : Fatal Pl/Sql error occured.
ORA-06502 : Pl/Sql : numeric or value error.

I had tried all solution by putting the exception handlers but did not get the result ???

Please advice

Ashutosh Trivedi
Re: Its urgent pelase try to help [message #190771 is a reply to message #190336] Fri, 01 September 2006 03:14 Go to previous messageGo to next message
Rehan Mirza
Messages: 63
Registered: July 2004
Location: Pakistan
Member

Please send yours formula column code or send yours report

take care
Its urgent pelase try to help [message #190873 is a reply to message #190771] Fri, 01 September 2006 13:40 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
thanks rehan for answer

I will send it to you ...

one more question i want to ask to you rather than asking in forum that if a function can return more than one value ? and if in the function can we pass the OUT, INOUT type of variable?


bye
A Trivedi
Re: Its urgent pelase try to help [message #190906 is a reply to message #190336] Sat, 02 September 2006 04:19 Go to previous messageGo to next message
Rehan Mirza
Messages: 63
Registered: July 2004
Location: Pakistan
Member

You are always welcome

Mind one thing that is function return more that one value mean more than one column, if it return more then one value from same column then it will give error.

please clear yours question......

take care
Its urgent pelase try to help [message #192482 is a reply to message #190906] Tue, 12 September 2006 09:57 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Dear Rehan,

I am facing a problem i.e when i run the reports from the menu then the reports gets hanged and no answer will come up.

Ultimately I have to shut down from task manager.

But still the problem is not solved.

What cud be the reason ????

Bye
Ashu
Re: Its urgent pelase try to help [message #192688 is a reply to message #192482] Wed, 13 September 2006 04:53 Go to previous messageGo to next message
zipdrivepacer
Messages: 1
Registered: September 2006
Location: Chennai
Junior Member
Hi Ashu

It cud be the reason for the error,the formula column could not accomadate the value.
Try increasing the width of the formula column to a maximum value like 500 and try testing the reports .

Let me know if u still have the issues.

Thanks and Regards
Deepak






Re: Its urgent pelase try to help [message #192807 is a reply to message #192482] Wed, 13 September 2006 12:55 Go to previous message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Dear Deepak & Mirza,

How are you? The problem is solved now report running and without any delay.

One of the tables from where the report is taking the data has multiple records of the same ID.

Anyway I will write to you if I face any problem in future.

Bye
Ashu

Previous Topic: REP-0549: Destination type must be 'File', 'Printer', 'Mail', or 'Sysout' in batch mode.
Next Topic: How to remove extra space in report output
Goto Forum:
  


Current Time: Fri Dec 09 01:47:47 CST 2016

Total time taken to generate the page: 0.09220 seconds