| Function in LOV [message #354217] |
Fri, 17 October 2008 01:19  |
Qaiser.Bashir
Messages: 32
Registered: July 2007
Location: Rawalpindi
|
Member |
|
|
Respected dears
i am facing a problem...i have create a Lov and in LOv query a function is called which take some input and process accordingly....when i use it it work fine....but after some period near about 6 months DBA make some changes and after that it does not work....he said that form is corrupted ...i have test this form on other four DBs..and there this form work fine...more over i ask him that i will make a new form...and i do so but it also create the same problem.....the query used in lov run on sql prompt...so DBA said that as it run on sql prompt so it means database is fine and there is a problem in form...i tried my best creat new one form too...but with out function it return records...and with function it does not return record and the form came on status of not responding...
more over is that when i use function and rownum function combine it reutrn the result....but at a certain limit...means my table contains 16000 and more record but if i ask him to return 100 record it will work fine but when i ask it to return all recoed it will goto not responding state...can any one provide me the solution
Regards
Qaiser Bashir
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Function in LOV [message #356540 is a reply to message #356532] |
Fri, 31 October 2008 01:40  |
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
|
Senior Member |
|
|
Dear Qaisar
in this function/ query you used 4 tables and you said that when you run this form on your pc it is working fine because you did not make any change, while your DBA made changes in database.
when you run on prompt at dba hand there is no any issue but issue raise on form .
are you receiving any error?
Can you get backup from your dba for testing purpose then check.
[Updated on: Fri, 31 October 2008 01:41] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Function in LOV [message #357834 is a reply to message #357655] |
Thu, 06 November 2008 21:17 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
I know you have said "that schema of databases is same" but I don't believe it. If YOU haven't done the comparison then I don't believe that they are all the same. The person telling you that they are the same doesn't have enough interest in solving your problem. It is up to you to prove to yourself that the five database instances are the same. Now, if four of them were restores of an original copy I would be more likely to believe that they are nearly the same. But then again if the export didn't include the indexes and roles, or was for a single user instead of all users then all bets are off.
The only other option is that the 'failing database' is either running a different version of Oracle or the hardware is different or the OS is different but you would have told us that information wouldn't you?
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
