Home » Developer & Programmer » Forms » Few typical queries
Few typical queries [message #387549] Thu, 19 February 2009 20:54 Go to next message
ind9
Messages: 65
Registered: January 2009
Member
Hi All,

Hope everyone is doing well. I have few queries and searching for the solutions. If anyone is aware of the following queries kindly share your information.

Queries are as follows.

1. I have 2 plls A & B. and each pll is containing functions with name x. This is not function overloading. Function with same name and with same number of parameters and datatype is also similar but different in implementation.
Now i have attached both the plls in the form. I have just called function by giving x.

Now which pll will be invoked? How the form decides to call either to call function x which is in the pll A or B.

2. Next query is i have 2 procedure X and Y.
     Procedure X is
       Cursor C1 is 
        Select * From Employees;
     Begin
         Records fetched from C1 say multiple records has to be passed to procedure Y as argument without using pl/sql tables.
--      Call to Procedure Y
         Y(Records of C1);
     End; 
       

How i can handle procedure Y to accept the passed records from Procedure X.

Thanks in advance. Kindly help.
Re: Few typical queries [message #387569 is a reply to message #387549] Thu, 19 February 2009 22:57 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
1) It depends. Unfortunately, I don't know on WHAT it depends. I have looked at this problem previously and have not found a definitive answer. In this situation, when in doubt don't!! Change the name in one of them.

2) Write it in PL/SQL and save it in the database.

David
[EDITED by DJM: typo - my name got 'chopped']

[Updated on: Mon, 23 February 2009 00:30]

Report message to a moderator

Re: Few typical queries [message #387575 is a reply to message #387569] Thu, 19 February 2009 23:12 Go to previous messageGo to next message
ind9
Messages: 65
Registered: January 2009
Member
Thanks for your reply.

Can you kindly brief second query answer.

Quote:
2) Write it in PL/SQL and save it in the database.
Re: Few typical queries [message #388010 is a reply to message #387575] Mon, 23 February 2009 00:31 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Write procedures 'X' and 'Y' in the database (versus in the Form) and do the work there.

David
Previous Topic: Import *.TXT data into Oracle Form
Next Topic: ora-01403
Goto Forum:
  


Current Time: Sat Dec 10 01:22:32 CST 2016

Total time taken to generate the page: 0.08430 seconds