| Package Related [message #192962] |
Thu, 14 September 2006 07:15  |
jai_162
Messages: 21
Registered: July 2006
|
Junior Member |
|
|
I have few queries:
1).Let say if we have a package 'A' & it contains pakage 'B' in it.Pacakage B contains package C.
If the pkg 'A' fails in execution.The package 'B' & package 'C' will become invalid.?
2).What is the main differences between Procedure & a package?
Eg: Package execution is faster its y so?
Why can't we do the same process in procedure & y we have to go for package?
3).Can the procedure can be overloaded?
4).Why do we use function instead of a procedure?Procedure can also return value by using OUT parameter?
5).Can LOV can be associated with more than one text item?If so how to have different return types for each text item?
Please try to answer my queries.
Regards
Jayaprakash K
|
|
|
|
| Re: Package Related [message #193000 is a reply to message #192962] |
Thu, 14 September 2006 09:24  |
Liza79
Messages: 74
Registered: September 2006
|
Member |
|
|
1). What do you mean by package A contains Package B?
If you mean that the Package B is written in the package C then clear your concept that the packages can neither be nested nor parameterized nor executed.
2) A procedure is a standalone program, which is an executable program but the packages are just used to bundle up the procedures and functions etc etc. The package cannot be executed.
3)Ya a procedure written inside a package can be overloaded.
4) A procedure cannot return a value with the help of return clause, therefore it cannot be called in a SQL SELECT statement or so....
5)yes LOV can be attached with multiple items just for the display purpose, but the return item will be the one always.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
