Skip to Main Content
Forums

Oracle Forms

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.

Do I need to Recompile the FORM

rkpMay 28 2008 — edited May 29 2008
Hi All,

I am using form 6i and database orcale9.2 version. I have one store procedure and this is called in many places. In the store procedure there was 10 in type (mode) parameters were passed. I am adding one new parameter to the store procedure with default value as a last parameter as below.

create procedure ins_pro (........, v_jflag emp.jflag%type := 'N') ...... .

I am inserting this parameter into the table. But after doing changes in the store procedure the form which is calling this store procedure is hanging. If I am recompile the form again then it is working properly.

Do I need to re-compile all the form which is calling this store procedure?

Regards

SUN

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 26 2008
Added on May 28 2008
#forms, #moved-from-devops
17 comments
1,949 views