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!

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
2,083 views