Home » Developer & Programmer » Forms » FRM-40513: ORACLE error: unable to get date/time from database. (Forms 11g)
icon6.gif  FRM-40513: ORACLE error: unable to get date/time from database. [message #596652] Wed, 25 September 2013 07:59 Go to next message
jaimeja76
Messages: 3
Registered: September 2013
Location: Asuncion Paraguay
Junior Member
after spent a lot of time surfing the web looking for this error frm-40513 i did not found any answer about this, So I've removed the date items on my canvas and ran perfectly... after that i opened another copy of the form. In one item there was a initial value $$DBDATETIME$$ .. so that was the error.. i removed that value and i ran my form 11g (weblogic) again and the error has gone. I just wanted to contribute with this solucion to this forum. thanks Cool
Re: FRM-40513: ORACLE error: unable to get date/time from database. [message #596695 is a reply to message #596652] Wed, 25 September 2013 12:48 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Thanks for sharing. Looks like you're not connected when $$DBDATETIME$$ is fetched from the DB:

FRM-40513: ORACLE error: unable to get date/time from database.
Cause: An error occurred while trying to resolve a database date/time initial value.
Action: Connect if you have not already done so. Verify database status.
Level: 10
Trigger: ON-ERROR
Re: FRM-40513: ORACLE error: unable to get date/time from database. [message #596701 is a reply to message #596695] Wed, 25 September 2013 13:11 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You said that you used $$DBDATETIME$$ as initial value for one of block items. What is that item's datatype? Should be CHAR or DATETIME. If it is not, try to set it to one of these datatypes, restore its initial value to $$DBDATETIME$$ and run the form again. What happens?
Re: FRM-40513: ORACLE error: unable to get date/time from database. [message #596702 is a reply to message #596701] Wed, 25 September 2013 13:16 Go to previous messageGo to next message
jaimeja76
Messages: 3
Registered: September 2013
Location: Asuncion Paraguay
Junior Member
the datatype is date but when i put just $$DBDATE$$ gives me the same error, when i use $$DATE$$ does not give me errors. I guess the word $$db_____$$ is the problem
Re: FRM-40513: ORACLE error: unable to get date/time from database. [message #596704 is a reply to message #596702] Wed, 25 September 2013 13:19 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
the datatype is date

I said CHAR or DATETIME, not DATE.
Re: FRM-40513: ORACLE error: unable to get date/time from database. [message #596831 is a reply to message #596702] Thu, 26 September 2013 10:31 Go to previous messageGo to next message
jaimeja76
Messages: 3
Registered: September 2013
Location: Asuncion Paraguay
Junior Member
i tried with datatype datetime and initial value to $$DBDATETIME$$ .. gave me the same error.. it works fine with datatype date and $$date$$ set to initial value
Re: FRM-40513: ORACLE error: unable to get date/time from database. [message #596861 is a reply to message #596831] Thu, 26 September 2013 15:10 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
OK then, if you say so ... I don't have Forms 11g so I can't test it.

Note that $$date$$ returns local system date, while $$dbdate$$ returns database date, and these two values can differ. Therefore, pay attention to what you use.

Some more info here (David's message).
icon14.gif  Re: FRM-40513: ORACLE error: unable to get date/time from database. [message #639332 is a reply to message #596652] Mon, 06 July 2015 06:14 Go to previous message
ahmedshaf3e
Messages: 1
Registered: July 2015
Location: Kuwait
Junior Member

Thanks you very much aimeja76 ,
really it helped me to much .
Previous Topic: Oracle Function Median
Next Topic: Delete Field
Goto Forum:
  


Current Time: Fri Mar 29 02:25:40 CDT 2024