Home » Developer & Programmer » Forms » Function in LOV (Form 6i)
Function in LOV [message #354217] Fri, 17 October 2008 01:19 Go to next message
qaiserbashirpk
Messages: 28
Registered: July 2007
Location: Rawalpindi
Junior 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 #354740 is a reply to message #354217] Tue, 21 October 2008 01:25 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
You say the form works on four databases but on the fifth. IS this correct? Use TOAD to compare the schemas.

David
Re: Function in LOV [message #354898 is a reply to message #354740] Tue, 21 October 2008 22:50 Go to previous messageGo to next message
qaiserbashirpk
Messages: 28
Registered: July 2007
Location: Rawalpindi
Junior Member

Respected Sir

Schema of all the fie DBs is same. so there is no difference in schema....



Regards
Re: Function in LOV [message #354930 is a reply to message #354898] Wed, 22 October 2008 00:22 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
So you are telling us that you have five 'exactly equal' databases, with the same userids, with the same roles and permissions, and your form work on four of them but not the fifth one. Is this correct?

David
Re: Function in LOV [message #354978 is a reply to message #354930] Wed, 22 October 2008 02:01 Go to previous messageGo to next message
qaiserbashirpk
Messages: 28
Registered: July 2007
Location: Rawalpindi
Junior Member

Now you understand it...you are now reached the actual situation.???and you said every word correctly..



Regards
Re: Function in LOV [message #355363 is a reply to message #354978] Thu, 23 October 2008 18:15 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Is that a 'yes'?

David
Re: Function in LOV [message #355386 is a reply to message #355363] Thu, 23 October 2008 22:12 Go to previous messageGo to next message
qaiserbashirpk
Messages: 28
Registered: July 2007
Location: Rawalpindi
Junior Member

Yes
Re: Function in LOV [message #356028 is a reply to message #355386] Wed, 29 October 2008 01:53 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Are you using the same copy of the form or do you have a different copy of the form accessing each of the different databases?

David
Re: Function in LOV [message #356192 is a reply to message #356028] Wed, 29 October 2008 22:01 Go to previous messageGo to next message
qaiserbashirpk
Messages: 28
Registered: July 2007
Location: Rawalpindi
Junior Member

Respected friend

I am using the same copy of the form to access each of the different databases.


Regards
Re: Function in LOV [message #356256 is a reply to message #356192] Thu, 30 October 2008 01:44 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
What did the DBA change?

David
Re: Function in LOV [message #356532 is a reply to message #356256] Fri, 31 October 2008 00:34 Go to previous messageGo to next message
qaiserbashirpk
Messages: 28
Registered: July 2007
Location: Rawalpindi
Junior Member

Dear David

i told in first mail that i donot know what dba has changed in databases...he is saying that he did not make any changes...but i insist that he has done some changes...now i donot know what to do....and what will be the solution...


Regards
Re: Function in LOV [message #356540 is a reply to message #356532] Fri, 31 October 2008 01:40 Go to previous messageGo to next message
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 #356864 is a reply to message #356540] Sun, 02 November 2008 22:45 Go to previous messageGo to next message
qaiserbashirpk
Messages: 28
Registered: July 2007
Location: Rawalpindi
Junior Member

Respected Kamran
Thank you very much for your interest in this regard. dear my query is not based on 4 tables it is based on 2 tables... i have five databases...and the form populate LOv on four databases but on one database it would not retutn any valus and the form displays no error but gone in to not responding state...


Regards

Qaiser Bashir
Re: Function in LOV [message #356877 is a reply to message #356864] Sun, 02 November 2008 23:38 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you tried taking the 'select' statement from each of the LOVs and running them manually against each of the databases?

David
Re: Function in LOV [message #356900 is a reply to message #356877] Mon, 03 November 2008 01:15 Go to previous messageGo to next message
qaiserbashirpk
Messages: 28
Registered: July 2007
Location: Rawalpindi
Junior Member

Respected David

Yes i have tried this too...and it works fine...


Regards
Re: Function in LOV [message #357537 is a reply to message #356900] Wed, 05 November 2008 16:48 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please confirm that you are using the same userid for ALL of your database accesses. That is, you have NO database links in your system and the userid owns ALL of the tables.

David
Re: Function in LOV [message #357576 is a reply to message #357537] Wed, 05 November 2008 22:22 Go to previous messageGo to next message
qaiserbashirpk
Messages: 28
Registered: July 2007
Location: Rawalpindi
Junior Member

Yes I have same userid for all databases.




Regards
Re: Function in LOV [message #357584 is a reply to message #357576] Wed, 05 November 2008 23:40 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do you have TOAD?

David
Re: Function in LOV [message #357588 is a reply to message #357584] Wed, 05 November 2008 23:58 Go to previous messageGo to next message
qaiserbashirpk
Messages: 28
Registered: July 2007
Location: Rawalpindi
Junior Member

No I Have Not TOAD...instead od TOAD i am using PLSQL Developer for this purpose....




Regards
Re: Function in LOV [message #357602 is a reply to message #357588] Thu, 06 November 2008 00:39 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do you have any tool with which YOU can do a compare of the databases?

David
Re: Function in LOV [message #357655 is a reply to message #357602] Thu, 06 November 2008 02:56 Go to previous messageGo to next message
qaiserbashirpk
Messages: 28
Registered: July 2007
Location: Rawalpindi
Junior Member

Dear David
i have already told you that schema of databases is same. some changes had been made by DBA...and as a developer i am unable to rectify that changes....Table structure ,constraints,synonyms etc are same for all databases on that specific tables from which i am accessing the data.




Regards
Re: Function in LOV [message #357834 is a reply to message #357655] Thu, 06 November 2008 21:17 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: How to Disable the entire form
Next Topic: Performance
Goto Forum:
  


Current Time: Sat Dec 03 16:09:33 CST 2016

Total time taken to generate the page: 0.09413 seconds