Commit Problem in ORACLE FORM 10g or the other version

hi, this morning i got a new case in commit problem.
this is the example problem.
in trigger when-button-pressed
insert into values ('aaa','bbb','ccc');
commit;

in trigger when-button-pressed
delete form where <> = < :itemName >
commit;

on that statement the oracle form can insert and delete the data in database, but some how i don't know why the database wouldn't commit that statement. to handled that problem you must replace the statement commit; into forms_ddl('commit');

example.
in trigger when-button-pressed
insert into values ('aaa','bbb','ccc');
forms_ddl('commit');

in trigger when-button-pressed
delete form where <> = < :itemName >
forms_ddl('commit');

this statement is built-in oracle form, it's can handled the issues dynamic SQL statement at runtime, include server-side PL/SQL and DDL. hmm.... i thinks just that i know how to solve the problem, if you had the other method to slove the problem please share it to us thanks :p

why my Oracle form 10g cannot run form ( CTRL+R)?

hello, guys i back again... this is the other problem i got it in trainning, may be some of you know how to solve this problem in oracle form 10g, and i hope you can share it with us if you had another way with me :p

ok, back to the topic i want to share to all of you who had the same problem like me, that when want to run form or CTRL + R , showing an error. because of that i want you to follow my step.

in the first time when open the "form builder" in oracle form 10g , please click edit -> preferences ,after that it's will showing the new windows with tab (General, Subclass, Wizards , RunTime)। Click RunTime and in application server URL click the button reset to default, after that browse the web browser location do you wanna use it. any way in my case, i use IE and Firefox to test it. but i just can solve the problem in IE, in firefox i no idea to solve it(may be other person can share with us ^_^). now open the IE then click the tools -> internet options
in the tab click Advanced, then in security area check "allow active content run in files on My Computer", then try to run the oracle form 10g.
oh....i forgot in the first run ( CTRL +R ) in the IE it will be ask to install the Jinitiator, you must install that, because if you don't have it, the application will not run in IE, and before runing the oracle form 10g, i hope i already start the OC4J because it's like IIS , apache / Virtual server.

that all i knew about how to running the form, i hope this article will solve the problem for many people, because the solution it's hard to find in internet.
thanks for read this article...

how to unlock/lock scott (oracle 10g)

hello guys, before write this article i had been trained for oracle 10g with the pl/sql and oracle form above 10 days and more, in many days i past it. i got some problem like the title said. in the first trained i must to create a new database in oracle 10g, differing with the other database, like MS SQL SERVER we cannot just click next, but some little think we must to concentration in some case, like the password for sys,system,etc (we must focus in this one because if you forgot or not write the password we cannot pass to SQL*PLUS to unlock the scott "user" or create the user to access the database, for the dispensation we must delete the database and create the new one) ,the other one is the unlock check box in the password management, if we don't uncheck for the scott "user" or the other "user" you want to unlock in the SQL*PLUS you can't use that's user because it's will be locked.

in that case you may use SQL*PLUS and login with SYS or SYSTEM and the password is the password that u write for that database when you do the created database wizard. after that i want you to use this step for unlock the user that you want it.

examples, in SQL*PLUS:
SQL> user scott identified by tiger account unlock;
or
SQL> user identified by unlock;

if you want to lock the scott "user" with the in SQL*PLUS, use this statement
SQL> --lock scott first
or
SQL> --lock first

well, i hope guy's who need this article will be seen it and can solve the problem...
thank's alot for read this article, see you in my next article