Home » SQL & PL/SQL » Client Tools » Problem with format (SQL * Plus)
Problem with format [message #276574] Thu, 25 October 2007 09:29 Go to next message
adrianbiccum
Messages: 9
Registered: October 2007
Junior Member
This is killing me!

It doesn't matter how big I make the format, I'm still getting #### as a total on my report...

help!?!?!
Re: Problem with format [message #276576 is a reply to message #276574] Thu, 25 October 2007 09:39 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
Make the format larger
Re: Problem with format [message #276581 is a reply to message #276574] Thu, 25 October 2007 09:48 Go to previous messageGo to next message
adrianbiccum
Messages: 9
Registered: October 2007
Junior Member
Hi, tried that already, I've set it to 999999, which is more than enough, and I'm still getting ####...
Re: Problem with format [message #276584 is a reply to message #276574] Thu, 25 October 2007 09:52 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
Are you sure it's enough ? Have you actually run the SQL and seen what the totals are ?
Re: Problem with format [message #276588 is a reply to message #276574] Thu, 25 October 2007 10:05 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
By DEFINITION when you see #### it means the mask can NOT display the value; so you must increase the mask size.
Or you can provide a test case & file a bug with Oracle.
Either Oracle is correct or you are.
Re: Problem with format [message #276589 is a reply to message #276574] Thu, 25 October 2007 10:05 Go to previous messageGo to next message
adrianbiccum
Messages: 9
Registered: October 2007
Junior Member
The maximum number I have is 40, 160 lines is only 6400, that's worst case; I tried setting the format to 99999999, that's 99 million....way more than enough...

I have no idea what's going on!
Re: Problem with format [message #276590 is a reply to message #276574] Thu, 25 October 2007 10:08 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
If I were a betting man, I'd place my money on PEBKAC.
Re: Problem with format [message #276592 is a reply to message #276574] Thu, 25 October 2007 10:13 Go to previous messageGo to next message
adrianbiccum
Messages: 9
Registered: October 2007
Junior Member
sorry what's PEBKAC?
Re: Problem with format [message #276605 is a reply to message #276592] Thu, 25 October 2007 10:43 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Problem Exists Between Keyboard And Chair. Grin
Re: Problem with format [message #276610 is a reply to message #276605] Thu, 25 October 2007 10:50 Go to previous messageGo to next message
adrianbiccum
Messages: 9
Registered: October 2007
Junior Member
Couldn't agree more at this point!! Thanks for your help folks I truly appreciate it!

Smile
Re: Problem with format [message #276690 is a reply to message #276610] Fri, 26 October 2007 00:29 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Does this last reply mean you solved it?

Do as Ctulhu suggested: run the query without formatting the fields, so you can actually see the results
Re: Problem with format [message #276841 is a reply to message #276690] Fri, 26 October 2007 07:44 Go to previous messageGo to next message
adrianbiccum
Messages: 9
Registered: October 2007
Junior Member
Not as yet, I'm running the query in sql developer to see what the results are supposed to be.

But I needed to get access to the tables first which I did yesterday...will test it today and figure it out.

I'm guessing it has something to do with the line size as well. I'm going to try the line size at 200, and work backwards. It has to be the format!

AB
Re: Problem with format [message #276859 is a reply to message #276841] Fri, 26 October 2007 08:40 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
run it in sqlplus, since you use sqlplus totalling.
Just leave out the column x format y statements
Re: Problem with format [message #276897 is a reply to message #276859] Fri, 26 October 2007 12:31 Go to previous message
adrianbiccum
Messages: 9
Registered: October 2007
Junior Member
As it turns out, it was the shell script that was pointing to the wrong code tree. So although I was making changes it wasn't pulling the script that I was I actually making changes to.

Always check the shell script!

AB
Previous Topic: Toad
Next Topic: How to find out some informations ?
Goto Forum:
  


Current Time: Sun Dec 04 12:32:05 CST 2016

Total time taken to generate the page: 0.13834 seconds