Home » Developer & Programmer » Forms » FRM-40508
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
Previous Topic: exit form (error 40735)
Next Topic: forms10g demo problem
Goto Forum:
  


Current Time: Wed Sep 18 18:18:09 CDT 2024