-
Forms 6i error
I have a table as varchar2 and created it using forms_ddl command in select the table name i am getting an error as invalid identifier .
Code is as follows tablename varchar2(20);
forms_ddl('create table '||tablename||' as select * from texas where pr_tx_perd ='||''''||:todt||''''|| ' and pr_tx_colm='||''''||'ex'||''''||' and
pr_tx_mode='||''''||'w'||'''');
select count(*) into cnt from pd_attn_new where
(pd_at_date,pd_at_rely,pd_at_tokn) in (select pr_tx_date,pr_tx_rely,pr_tx_tokn from tablename) and pd_at_date between :frdt and :todt and nvl(pd_at_prdn,0) > 0;
while compiling in forms6i i am getting an error pls check it
-
Re: Forms 6i error