Skip to Main Content

APEX

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!

PL/SQL anonymous block problem with APEX

788177Jul 5 2011 — edited Jul 5 2011
Hello,

I have an APEX application where on click of a button I call a PL/SQL procedure like
BEGIN
    myPackage.myProcedure(:F101_NBR, :P3_ASSIGN_TO);
END;
Say this procedure, inserts a new row in database.
I am having 2 problems

1. First of all this works only from IE and Firefox, clicking that button in Chrome results in no errors, but I don't see
new row getting inserted in the database
2. I exported this application, deleted existing one and imported it back, by running @f101 script, (f101.sql had the exported application) and now this has stopped working even with IE and Firefox.

Can someone tell what is going on and how can this be debugged?

regards, Yora
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 2 2011
Added on Jul 5 2011
3 comments
511 views