Results 1 to 2 of 2

Thread: Forms 6i error

  1. #1
    Geek_Guest
    Guest

    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


  2. #2
    Expert Member
    Join Date
    Dec 2006
    Answers
    204

    Re: Forms 6i error

    whats the error?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact