Home » Developer & Programmer » Forms » Forms DDL
Forms DDL [message #82668] Fri, 20 June 2003 10:21
Abhijit Moharil
Messages: 1
Registered: June 2003
Junior Member
I am trying to do forms ddl for dydnamically created update statement below. Some how it's felling

v_sql := 'UPDATE tax_return_rep SET CELL_' ||
LPAD(TO_CHAR(fcd_rec.fc_seq_no), 3, 0) || ' = ' ||
fcd_rec.taxpayer_amt_no || ' WHERE vtrt_key = ' || v_rep_seq;

forms_ddl('begin'||v_single_quote||v_sql||v_single_quote||';end;');

Please advise..Thanks
Previous Topic: ITS A MATTER OF JOB
Next Topic: Query not returning all records
Goto Forum:
  


Current Time: Fri Mar 29 08:40:01 CDT 2024