Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
#in, #oracle, #parameter, #pl-sql, #plsql
5 comments
2,584 views