Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Stored Procedure DEFAULT Input parameter is not getting assigned to the input variable.

1043226Mar 7 2014 — edited Mar 7 2014

Hi ,

I have stored procedure being called from a Concurrent Program. The Procedure has 4 input parameters and all have DEFAULT values. When I call the procedure through CP and pass no input vlaues , the default values are not getting assigned to the input parameters.

   PROCEDURE main (p_errbuf_o                  OUT VARCHAR2,

                   p_retcode_o                 OUT NUMBER,

                   p_updt_lastest_cost_i    IN     VARCHAR2 DEFAULT 'Y' ,

                   p_new_planned_items_i      IN     VARCHAR2 DEFAULT 'Y' ,

                   p_master_org_copy_cost_i   IN     VARCHAR2 DEFAULT 'N' ,

                   p_debug_msg_on_i         IN     VARCHAR2 DEFAULT 'Y' );

when i print the parameter its having null values.

Thank you,

Amshuman.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 4 2014
Added on Mar 7 2014
5 comments
2,817 views