Home » Developer & Programmer » Forms » ora-01008
ora-01008 [message #224517] Wed, 14 March 2007 09:07 Go to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

Hii All

I am using a "when-validate-item" trigger on an item

that contain that code
	SELECT GRR_CODE 
	INTO  :SRO.GCORR_GRR_CODE
	FROM   GCUxxxxxx
	WHERE  CODE = :SRO.GCU_CODE ;
	

the field that i am validating on it is ":SRO.GCU_CODE "
ant it should put "grr_code" in to the field ":SRO.GCORR_GRR_CODE"

but i got that error

WHEN-VALIDATE-ITEM trigger raised unhandled exception
ora-01459
ora-01008 : not all variables bound


Thanks for everyone helped and helping me
Re: ora-01008 [message #224519 is a reply to message #224517] Wed, 14 March 2007 09:12 Go to previous messageGo to next message
emadbsb
Messages: 334
Registered: May 2005
Location: egypt
Senior Member

I got the solution

i have to make declaration to a variable and but in it the value
something like this

DECLARE
	vGRORR_GRR_CODE NUMBER;
	
BEGIN
	
	SELECT GRR_CODE 
	INTO  vGRORR_GRR_CODE
	FROM   GCUxxxxxx
	WHERE  CODE = :SRO.GCU_CODE ;
	
	
	:SRO.GCORR_GRR_CODE := vGRORR_GRR_CODE;
	
END;




i want to know exactly why is that
Re: ora-01008 [message #225458 is a reply to message #224519] Tue, 20 March 2007 00:23 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Check the data types.

David
Previous Topic: ora-106556
Next Topic: migration to forms 6i from forms 3 and Conversion of forms 2.4 to forms 3.0 (merged)
Goto Forum:
  


Current Time: Sun Dec 04 08:58:32 CST 2016

Total time taken to generate the page: 0.09195 seconds