-
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
-
Expert Member
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules