create or replace my_demo_proc (param_1 in varchar2, param_2 in number) is begin null; end;
Now param_1 and param_2 are named parameters but begin my_demo_proc('ABC', 20); end; / The "ABC" and 20 are actual parameters. Named parameters are also known as formal parameters. ______________________________________________________ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!
*******************************************************************************1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *******************************************************************************1