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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 07 09:53:52 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.