OraFAQ Forum: Forms » FRM-40513: ORACLE error: unable to get date/time from database.

Home » Developer & Programmer » Forms » FRM-40513: ORACLE error: unable to get date/time from database. (Forms 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

FRM-40513: ORACLE error: unable to get date/time from database. [message #596652]

Wed, 25 September 2013 07:59

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

Report message to a moderator

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

Frank Naude
Messages: 4595
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

Report message to a moderator

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

Littlefoot
Messages: 21823
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?

Report message to a moderator

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

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

Report message to a moderator

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

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

the datatype is date

I said CHAR or DATETIME, not DATE.

Report message to a moderator

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

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

Report message to a moderator

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

Littlefoot
Messages: 21823
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).

Report message to a moderator

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

ahmedshaf3e
Messages: 1
Registered: July 2015
Location: Kuwait

Junior Member

Thanks you very much aimeja76 ,
really it helped me to much .

Report message to a moderator

Previous Topic:	master-Detail n others
Next Topic:	Delete Field

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 13 00:05:18 CDT 2025