OraFAQ Forum: Forms » Form error 40505 with an ORA-00000 error

Home » Developer & Programmer » Forms » Form error 40505 with an ORA-00000 error (forms 10g)

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

Form error 40505 with an ORA-00000 error [message #493037]

Fri, 04 February 2011 06:18

monkey_suit
Messages: 21
Registered: February 2011

Junior Member

okay so i get this error when a block query is executed after a value has been selected from a LOV. i checked the help and it gives the ORA-00000 ???non error??? i copied the so called problem query and it executes perfectly in sqldeveloper. If anyone has experienced similar problems please advise.

Report message to a moderator

Re: Form error 40505 with an ORA-00000 error [message #493040 is a reply to message #493037]

Fri, 04 February 2011 06:21

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

Senior Member
Account Moderator

Go to Help menu and select "Display error". It should display the reason why Oracle can't perform query.

Report message to a moderator

Re: Form error 40505 with an ORA-00000 error [message #493041 is a reply to message #493040]

Fri, 04 February 2011 06:22

monkey_suit
Messages: 21
Registered: February 2011

Junior Member

it gives the ORA-00000 error

Report message to a moderator

Re: Form error 40505 with an ORA-00000 error [message #493057 is a reply to message #493037]

Fri, 04 February 2011 08:10

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

I have received this error sometimes too. 0000 means no error. It's just an informational message, however, I was determined to get rid of it and I went back to a previous version of my form and put the code back in and it was gone. It seems I may have introduced some problem and when I redid my changes on a working form, it was gone.
Sometimes Forms is a little finicky and things like this happen.

p.s. I was getting the 0000 error on committing when there were no changed to be saved.

Report message to a moderator

Re: Form error 40505 with an ORA-00000 error [message #493107 is a reply to message #493057]

Fri, 04 February 2011 23:17

shaz
Messages: 182
Registered: June 2009

Senior Member

I also received this error once. I saved my form and restarted the developer again and then it was gone. Smile

Report message to a moderator

Re: Form error 40505 with an ORA-00000 error [message #493231 is a reply to message #493107]

Sun, 06 February 2011 23:27

monkey_suit
Messages: 21
Registered: February 2011

Junior Member

i get this error when i select a value from a LOV and it tries to populate a datablock with values based on the value that was selected. I tried restarting forms developer still no joy.

Report message to a moderator

Re: Form error 40505 with an ORA-00000 error [message #493237 is a reply to message #493231]

Mon, 07 February 2011 00:37

monkey_suit
Messages: 21
Registered: February 2011

Junior Member

okay i have managed to get rid of the error and have the form function properly again. i took joy_division advice and "sort of" revert to the most recent working code but through a process of elimination. essentially the problem was an incorrect data type for a text item, the query returns a varchar but the text item's data type property was a number, i changed it to accept varchars and had it working again.

Report message to a moderator

Previous Topic:	Tree View Query
Next Topic:	How center image icons on d2k button on 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 16:22:12 CDT 2024