FRM-40508 [message #87101] |
Mon, 06 December 2004 11:59 |
Scoodels
Messages: 8 Registered: November 2004
|
Junior Member |
|
|
Hi!!
I have a problem in inserting values into table usinf Forms.
here is my code
Insert into STG_DIVIDENDS_PAID(ID,status_code,distributed_amount,dividend_type,dividend_rate,
ex_date,declared_date,lse_id) values
(SEQ_STAGE.NEXTVAL,'P',:UPDATE_DIVIDENDS_PAID.distributed_amount ,
:UPDATE_DIVIDENDS_PAID.dividend_type,
:UPDATE_DIVIDENDS_PAID.dividend_rate,
:UPDATE_DIVIDENDS_PAID.ex_date,
:UPDATE_DIVIDENDS_PAID.declared_date,v_temp);
here :update_dividends_paid is my datablock, which is based on a view.
The above insert statement is giving me FRM-40508 error. can anybody help me.
Thanks
|
|
|