OraFAQ Forum: Forms » Calling Procedure at (Form, Library and Database) level

Home » Developer & Programmer » Forms » Calling Procedure at (Form, Library and Database) level

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

Calling Procedure at (Form, Library and Database) level [message #500007]

Thu, 17 March 2011 04:15

Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi

Senior Member

Hi,

I've a procedure let us say SALES_PROC on Form Level and same procedure in Library and in Database also.

How to call SALES_PROC created at Form Level?
How to call SALES_PROC created at Library Level (.PLL)?
How to call SALES_PROC created as stored procedure in Database?

Thanks & Regards
Manoj

Report message to a moderator

Re: Calling Procedure at (Form, Library and Database) level [message #500016 is a reply to message #500007]

Thu, 17 March 2011 04:34

infosuresh2k
Messages: 77
Registered: September 2009
Location: CHENNAI, INDIA

Member

Hi,

If you have same procedure sale_proc in pll, program unit and database level then you have to call like below

1.database sale_proc you can call with schema name like scott.sale_proc

2. if you have same procedure in pll and program unit then it will take program unit sale_proc only not from pll proc(program unit is first priority is both procedures are same).

Regards,
Suresh.V

Report message to a moderator

Re: Calling Procedure at (Form, Library and Database) level [message #500018 is a reply to message #500016]

Thu, 17 March 2011 04:42

Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi

Senior Member

Hi,

(1) I don't want to use schema name in any context.
(2) Although this is not a general scenario but still want to know calling method for all 3 procedures separately.

Thanks & Regards
Manoj

Report message to a moderator

Re: Calling Procedure at (Form, Library and Database) level [message #500036 is a reply to message #500018]

Thu, 17 March 2011 06:04

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

You just shouldn't have a system where you have the same procedure name at all three levels - it's just bad design.
If you don't use schema name you will not be able to call the db proc as the form proc will always take precedence.
The pll and db procs should always be within packages, then you can reference them by package name.
Basically forms looks in the form for a match, then any attached plls, then the db.

Report message to a moderator

Re: Calling Procedure at (Form, Library and Database) level [message #500038 is a reply to message #500036]

Thu, 17 March 2011 06:12

Manoj.Gupta.91
Messages: 239
Registered: March 2008
Location: Delhi

Senior Member

Hi,

@cookiemonster

I know that I can call database stored procedure using Schema name.

This is bad design practive...I know. But this is still possible that we have a procedure with the same name at all three levels.

I've been asked this question so many times in interviews. I'm uable to find out a complete solution for this.

Please advise...

Thanks & Regards
Manoj

Report message to a moderator

Re: Calling Procedure at (Form, Library and Database) level [message #500040 is a reply to message #500038]

Thu, 17 March 2011 06:21

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

The complete solution is don't do it.
You can not call a db function if there is a form function of the same name (assuming they also have the same parameter list, if they don't it'll call whichever one matches the parameter list (probably - I haven't checked)) unless you use the schema name.
There is no way round this.

Report message to a moderator

Previous Topic:	changes made in forms not getting effected in front end
Next Topic:	ORA-00001: unique constraint

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 13:58:44 CST 2025