Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: call_form cannot commit an SQL insert statement
do this
in the code where you do your commit. just before you attempt to do it.. do
message(:system.record_status); pause
it probably says 'query'
if that is the case do the following
set_record_property(read help for what to put here. set it to 'changed')
then commit.
"Ta Xiong7" <ta_xiong7_at_hotmail.com> wrote in message
news:abph4f$n5v$1_at_coco.singnet.com.sg...
> Hi guys
> i'm having this problem with commiting an SQL statement (in a form
> procedure)
> scenario:
> i have formA calling formB and a procedure in formB that inserts and
commits
> a record into an audit table, eg.
> insert into tableB values('a','b','c');
> commit;
>
> however, i can only commit the record if i'm in a new record in formA and
> double-click to trigger the call to formB. if i were to trigger it from
an
> existing record in formA, record would not be commited in formB. strange
> thing is it did not return any error, exception was not triggered. i even
> displayed the sqlerrm and err_text but all says ok.
>
> further testing i found out if i were to call formB from an existing
record
> and exit back to formA and then trigger it again in a new record in formA,
> it was not able to commit the record.
>
> so it works only if i trigger it on a new record in formA and must not
> trigger it on an existing record even if i later trigger it on a new
record
>
> anybody has faced this problem. hope someone can help.
> appreciate if you also reply to my email at richard_tay_at_singstat.gov.sg
> thanks a million ;-)
>
>
>
Received on Mon May 13 2002 - 18:44:31 CDT