Prepare for your Next Interview
This is a discussion on Forms 6i error within the Oracle forums, part of the Databases category; 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 ...
|
|||
|
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 |
| Sponsored Links |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| oracle forms and reports 6i question | tushar.chitnis | Oracle Apps | 0 | 04-26-2007 08:53 AM |
| Where and how should I start from to learn Oracle Forms | Geek_Guest | Oracle | 0 | 04-19-2007 05:45 AM |
| Forms are appearing BLACK, What is the reason | Geek_Guest | Oracle Apps | 0 | 04-03-2007 12:17 PM |
| oracle forms | clairemckenna | Oracle | 0 | 03-15-2007 08:28 AM |
| Heard about different forms of printf and scanf | joel | C and C++ | 3 | 06-29-2006 02:26 PM |