Home » Developer & Programmer » Forms » FRM-40735:WHEN-BUTTON-PRESSED (form 9i)
FRM-40735:WHEN-BUTTON-PRESSED [message #407437] Wed, 10 June 2009 03:22 Go to next message
aiznu
Messages: 24
Registered: May 2009
Junior Member
help me..
why i got this error after i click the button
FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502
it is my coding error?
this is my coding
declare
	n NUMBER;
	my_stmt VARCHAR2(2000); 
BEGIN my_stmt := 'create table '||:table.table_name||'('||:table.COL||' NUMBER'; 
	FOR I in 2..N LOOP 
		my_stmt := my_stmt||',COL'||TO_CHAR(i)||' NUMBER'; 
	END LOOP; 
	my_stmt := my_stmt||')'; 
	/* ** Now, create the table... */ 
Forms_DDL(my_stmt); 
IF NOT Form_Success THEN 
	Message ('Table Creation Failed'); 
ELSE Message ('Table Created'); 
END IF; 
END;
Re: FRM-40735:WHEN-BUTTON-PRESSED [message #407451 is a reply to message #407437] Wed, 10 June 2009 04:07 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Quote:
n NUMBER;
n is not initialized.

By
Vamsi
Re: FRM-40735:WHEN-BUTTON-PRESSED [message #407456 is a reply to message #407451] Wed, 10 June 2009 04:34 Go to previous messageGo to next message
aiznu
Messages: 24
Registered: May 2009
Junior Member
if i change n to N, the error is same.
FRM-40735:WHEN-BUTTON-PRESSED trigger raised unhandled exception ORA-06502
Re: FRM-40735:WHEN-BUTTON-PRESSED [message #407457 is a reply to message #407456] Wed, 10 June 2009 04:45 Go to previous messageGo to next message
ADNANTARIQ_85
Messages: 18
Registered: June 2009
Location: Faisalabad
Junior Member

please focus red line which you missing (12 is a n value)

declare
n NUMBER;
my_stmt VARCHAR2(2000);
BEGIN my_stmt := 'create table '||:table.table_name||'('||:table.COL||' NUMBER';
number :=12;
FOR I in 2..N LOOP
my_stmt := my_stmt||',COL'||TO_CHAR(i)||' NUMBER';
END LOOP;
my_stmt := my_stmt||')';
/* ** Now, create the table... */
Forms_DDL(my_stmt);
IF NOT Form_Success THEN
Message ('Table Creation Failed');
ELSE Message ('Table Created');
END IF;
END;


Understand ?



M. Adnan Tariq
JK.Group
Re: FRM-40735:WHEN-BUTTON-PRESSED [message #407459 is a reply to message #407457] Wed, 10 June 2009 04:47 Go to previous messageGo to next message
ADNANTARIQ_85
Messages: 18
Registered: June 2009
Location: Faisalabad
Junior Member

sorry
n:=12
Re: FRM-40735:WHEN-BUTTON-PRESSED [message #407460 is a reply to message #407459] Wed, 10 June 2009 04:57 Go to previous messageGo to next message
aiznu
Messages: 24
Registered: May 2009
Junior Member
has got error. the error is 'Table Creation Failed'. why?
and i want to know why must put n:=12?
Re: FRM-40735:WHEN-BUTTON-PRESSED [message #407464 is a reply to message #407460] Wed, 10 June 2009 05:12 Go to previous messageGo to next message
ADNANTARIQ_85
Messages: 18
Registered: June 2009
Location: Faisalabad
Junior Member

dear

you use "form not success" if any error i think error is you have already create a table same name and you know in one schema have not same name table dear DDL is auto commit .OK
second
12 is not must you use infinite (for loop) and n is not define i mean n size no define so dear 12 is just for example you use any



Understand ??????????


M. Adnan
Re: FRM-40735:WHEN-BUTTON-PRESSED [message #407472 is a reply to message #407464] Wed, 10 June 2009 05:26 Go to previous messageGo to next message
aiznu
Messages: 24
Registered: May 2009
Junior Member
i understand the error already create from 'form not success'..but why the form not success.i select the table but does not exist.
and the second.. i understand.thanks you for explain me detail.
Re: FRM-40735:WHEN-BUTTON-PRESSED [message #407482 is a reply to message #407472] Wed, 10 June 2009 05:37 Go to previous messageGo to next message
ADNANTARIQ_85
Messages: 18
Registered: June 2009
Location: Faisalabad
Junior Member

lol

dear i think you tired so please rest ....tri to nxt dy
Re: FRM-40735:WHEN-BUTTON-PRESSED [message #407732 is a reply to message #407482] Thu, 11 June 2009 05:53 Go to previous message
aiznu
Messages: 24
Registered: May 2009
Junior Member
thanks you ADNANTARIQ_85, vamsi kasina Smile
i success create table.
Previous Topic: Error with inner select statement
Next Topic: field not displaying full value
Goto Forum:
  


Current Time: Fri Dec 02 20:49:34 CST 2016

Total time taken to generate the page: 0.10732 seconds