OraFAQ Forum: Forms » ora-01008

Home » Developer & Programmer » Forms » ora-01008

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-01008 [message #224517]

Wed, 14 March 2007 09:07

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

Report message to a moderator

Re: ora-01008 [message #224519 is a reply to message #224517]

Wed, 14 March 2007 09:12

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

Report message to a moderator

Re: ora-01008 [message #225458 is a reply to message #224519]

Tue, 20 March 2007 00:23

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Check the data types.

David

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Dec 05 15:55:55 CST 2024