Geeks Talk

Prepare for your Next Interview




Forms 6i error

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 ...


Go Back   Geeks Talk > Databases > Oracle

Register FAQ Members List Calendar Mark Forums Read
  #1 (permalink)  
Old 04-29-2007
Expert Member
 
Join Date: Feb 2007
Posts: 1,279
Thanks: 0
Thanked 164 Times in 138 Posts
Geek_Guest is on a distinguished roadGeek_Guest is on a distinguished road
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
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 04-30-2007
Expert Member
 
Join Date: Dec 2006
Location: Chennai
Posts: 197
Thanks: 2
Thanked 16 Times in 14 Posts
Barbie is on a distinguished road
Re: Forms 6i error

whats the error?
Reply With Quote
Reply

  Geeks Talk > Databases > Oracle


Thread Tools
Display Modes


Similar Threads

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


All times are GMT -4. The time now is 12:50 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Copyright © 2008 GeekInterview.com. All Rights Reserved