OraFAQ Forum: Forms » Few typical queries

Home » Developer & Programmer » Forms » Few typical queries

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

Few typical queries [message #387549]

Thu, 19 February 2009 20:54

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.

Report message to a moderator

Re: Few typical queries [message #387569 is a reply to message #387549]

Thu, 19 February 2009 22:57

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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