What should I do? You want to convert your strings into dates, and then sometimes extract part of them back out again, and so you need to rewrite your query like this: select hostname ,to_char(to_date(&date_today,'yyyymmdd') Is the sum of two white noise processes also a white noise? Senior MemberAccount Moderator Michel Cadot wrote on Fri, 17 October 2008 09:50Use SQL*Plus and copy and paste your session.

Can two different firmware files have same md5 sum? My input for the variables fromDate and toDate are just date strings such as 20111010 etc. Why can't QEMU allocate the memory if the Linux caches are too big? The error goes away, but now when I try to fetch the row (from a link in a report) that column does not now up in the form.

So, please open up sqlplus. while calling a stored procedure, how can i solve this0Updating row of one table using rows of another table based on specific conditions4Conditional formatting based on number of days in SSRS Christopher R. In Skyrim, is it possible to upgrade a weapon/armor twice?

Is it a fallacy, and if so which, to believe we are special because our existence on Earth seems improbable? Why is cell potential defined as E0[Reduction]-E0[Oxidation] and not the reverse? Are oÍo and ü interchangeable? Please enter a title.

It should be possible to up-vote twice ;) –julumme Nov 15 '15 at 23:03 add a comment| Did you find this question interesting? Report message to a moderator Re: error ORA-01481 [message #354247 is a reply to message #354240] Fri, 17 October 2008 03:11 Frank Messages: 7880Registered: March 2000 Senior Member I have a row_fetch on a sequence number PK and am getting this error. Like Show 0 Likes(0) Actions 4.

To start viewing messages, select the forum that you want to visit from the selection below. This data is ONE column with NUMBER(8). Which news about the second Higgs mode (or the mysterious particle) anticipated to be seen at LHC around 750 GeV? There haven't been any comments added for this error yet.

If you are using APEX_ITEM to control your form, be careful to allow enough space for the entire number to fit, or to round/truncate it in your initial query. Please type your message and try again. Your col1 can hold bigger values than 99.99. I removed the number format from the one column that had one.

Is there any solution to to change "Date / Number Format" to something like list from where format mask can be selected ? Does this operation exist? Report message to a moderator Re: error ORA-01481 [message #354237 is a reply to message #354231] Fri, 17 October 2008 02:45 ejoeyz_85 Messages: 30Registered: October 2008 Member i Simulate keystrokes What are the drawbacks of the US making tactical first use of nuclear weapons against terrorist sites?

You can not post a blank message. Regards, Patrick Like Show 0 Likes(0) Actions Go to original post Actions About Oracle Technology Network (OTN)My Oracle Support Community (MOSC)MOS Support PortalAboutModern Marketing BlogRSS FeedPowered byOracle Technology NetworkOracle Communities DirectoryFAQAbout Invariants of higher genus curves English equivalent of the Portuguese phrase: "this person's mood changes according to the moon" Wrong password - number of retries - what's a good number to I could be wrong Reply With Quote 05-19-2008,04:06 PM #3 NBSR View Profile View Forum Posts Junior Member Join Date May 2008 Posts 34 Yes it does and i have removed

Make sure that lines of code do not exceed 80 characters when you format. Senior MemberAccount Moderator Quote:anything wrong? What would happen if I created an account called 'root'? When I comment out MEAS_IND I get the error that it cannot be null, so I am assuming that the other columns are fine.

i have changed the statement like this: Quote:select hostname, to_char(to_date(&date_today, 'YYYYMMDD') , 'YYYY'), to_char(to_date(&date_today, 'YYYYMMDD') , 'WW'), genesis_port, instance_name, api_name, sum(total_time), max(max_time), min(min_time), (sum(total_time)/sum(count)), sum(count) from gen_api_performance_daily where statistics_date between to_date(&date_last_week, I rounded the number and that seems to have worked. If indicated air speed does not change can the amount of lift change? Report message to a moderator Re: error ORA-01481 [message #354244 is a reply to message #354240] Fri, 17 October 2008 03:08 JRowbottom Messages: 5933Registered: June 2006 Location: Sunny

Action: Consult your manual. Does the string "...CATCAT..." appear in the DNA of Felis catus? What's its name? Subscribed!

Try our newsletter Sign up for our newsletter and get our top new questions delivered to your inbox (see an example). These values will give ###### as a result and also the value will be rounded on 2 decimals by the to_char command. current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. This tool uses JavaScript and much of it will not work correctly without it enabled.

I have tried also more specific time (same format as in the table), but that doesn't seem to be the problem.. Why no just create a view that returns the formatted number? –a_horse_with_no_name Sep 4 '15 at 14:16 add a comment| 2 Answers 2 active oldest votes up vote 3 down vote Not the answer you're looking for? Unfortunately I get same error even with dashes (I tried: without dashes as input, with dashes as input, and also dashes for the TO_CHAR parameter) –julumme Nov 13 '15 at 7:10

Also, '20111010' is not a DATE, it is a STRING. error occured then.. You may have to register before you can post: click the register link above to proceed. In addition to the datetime elements of the DATE datatype, the TIMESTAMP datatype holds fractions of a second to a precision between 0 and 9 decimal places, the default being 6.

Re: ORA-01481: invalid number format model jareeq Oct 19, 2011 12:29 PM (in response to 510477) Hi, i got this error on APEX 4.1 after trying to load data (with load Re: ORA-01481: invalid number format model 510477 May 13, 2010 4:32 PM (in response to 325647) Can you give us an idea of the query you are using? Results 1 to 3 of 3 Thread: Help to remove error ORA-01481 Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Paste your query enter the requested items copy the complete session come back here reply to this message include the contents of your clipboard in [CODE]-tags, not as a QUOTE.

Is it permitted to not take Ph.D. Use the "Preview Message" button to verify.

Please understand this is beyond the support area of Microsoft. Make sure the host, port and service name specified are correct. Verify that the net service name or database name used as the connect identifier is configured in the directory. Check the "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\ALL_HOMES\HOME_COUNTER" key value. 10. Verify that a tnsnames.ora file exists and is in the proper directory and is accessible. If it exists then make sure it has the right value as ?Dir:\app\pro...

Get 1:1 Help Now Advertise Here Enjoyed your answer? On Windows 2000, Windows XP, and Windows Server 2003 from the System Properties window select the Advanced tab and click on the Environment Variables button. It occurs when one or more of these conditions is true: 1. Reply 22 Gaurav Rachchh January 16, 2009 at 12:41 pm Hi , We are using secure oracle 10g instant client on windows XP and using oracle 10g server enterprise edition on Rebooting is only required when you have applicati...

Action: Inspect the internal exception and check the Java manuals. Action: Specify the attribute name in the mapping by calling method /TOC=h27. But if the file was manually edited or corrupted then the files must be generated again. Extract the above settings from the alert.log and startup with that temporary pfile. Personal tools Namespaces Article Search Main Page Applications AOL Internet Explorer MS Outlook Outlook Express Windows Live DLL Errors Exe Errors Ocx Errors Operating S...

Error code: 109 WRITE_LOCK_FIELD_IN_CHILD_DESCRIPTOR Cause: The child descriptor should not have a write lock field defined because it gets it from the parent descriptor. Action: Call method /TOC=h26 to set the fields. Action: Inspect the internal exception and check the Java manuals. Java throws security exception when creating Method type from the given method name using Java reflection. Action: Inspect the internal exception and check the Java manuals. The number of actual and forma...