Home » Other » 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!?!?!
  • Attachment: swrenrl_2.txt
    (Size: 9.48KB, Downloaded 1977 times)

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
Senior Member
Make the format larger

Report message to a moderator

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 ####...

Report message to a moderator

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 ?

Report message to a moderator

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: 26766
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.

Report message to a moderator

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!

Report message to a moderator

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: 26766
Registered: January 2009
Location: SoCal
Senior Member
If I were a betting man, I'd place my money on PEBKAC.

Report message to a moderator

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?

Report message to a moderator

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: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Problem Exists Between Keyboard And Chair. Grin

Report message to a moderator

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

Report message to a moderator

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: 7901
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

Report message to a moderator

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

Report message to a moderator

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: 7901
Registered: March 2000
Senior Member
run it in sqlplus, since you use sqlplus totalling.
Just leave out the column x format y statements

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 20:27:00 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.