Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

temporary table

781692Dec 9 2010 — edited Dec 9 2010

hi all i am using Forms [32 Bit] Version 6.0.8.24.1 (Production)
i am aware of creation of global temporary table through back end,but i am trying to create in the form itself. is its possible.I tried like below..
i suppose to check for the duplication. so after inserting into the table i will query for that combination if count > 1 then the duplicate record exists.
so i have created as below

 forms_ddl('create global temporary table temptable(A_COMPANY varchar2(5),A_CODE varchar2(15),A_NAME varchar2(240),A_L_PORT varchar2(15),A_T_PORT varchar2(15),A_T_RATE number,A_VOLUME number,A_CRT_ON date,A_CRT_BY varchar2(15);');
	IF NOT Form_Success THEN 
     Message ('Table Creation Failed');
  ELSE
     Message ('Table Created'); 
  END IF;

but i am getting the message 'table creation failed'.. what i am missing here. is this is the way to create temp tables?

Thanks..

Edited by: user13329002 on Dec 8, 2010 10:22 PM

Edited by: user13329002 on Dec 8, 2010 11:42 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 6 2011

Added on Dec 9 2010

#forms, #moved-from-devops

9 comments

1,435 views