Home » Developer & Programmer » Forms » Pl/sql Table problem (form 6i)
Pl/sql Table problem [message #324323] Mon, 02 June 2008 00:35 Go to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

Hi,

Im using forms 6i and I create the code like below in "when-button-pressed"


Type RecType is Table of 
	        Rpart Partmaster.partnumber%type
	        INDEX BY BINARY_INTEGER;
	    TRecType RecType; 



but im getting compilation error;

error 103 at line 5, column 16
  Encountered the symbol "PARTMASTER" when expecting one of the following

.{@ % ; not null range index character
The symbol "." was substituted for "PARTMASTER" to continue.


Any one please help me.

wbr
kanish
Re: Pl/sql Table problem [message #324401 is a reply to message #324323] Mon, 02 June 2008 06:06 Go to previous messageGo to next message
mailtokkalyan
Messages: 65
Registered: December 2006
Location: Bangalore
Member
Hi
Use Like this....

Type Rec is Record (Rpart Partmaster.partnumber);
Type RecType is Table of rec INDEX BY BINARY_INTEGER;
TRecType RecType;

Regards,
Kalyan

[Updated on: Mon, 02 June 2008 06:07]

Report message to a moderator

Re: Pl/sql Table problem [message #324514 is a reply to message #324323] Mon, 02 June 2008 22:54 Go to previous messageGo to next message
mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai
Senior Member

Thanks Kalayan


I Got it and i dont why the previous case is not working.


wbr
Kanish
Re: Pl/sql Table problem [message #326371 is a reply to message #324514] Wed, 11 June 2008 04:50 Go to previous messageGo to next message
mailtokkalyan
Messages: 65
Registered: December 2006
Location: Bangalore
Member
hi kanish,
sorry for late reply...Previous case will not work. coz that is not a record.

Regards,
Kalyan
Re: Pl/sql Table problem [message #326469 is a reply to message #324323] Wed, 11 June 2008 10:29 Go to previous message
Martin Eysackers
Messages: 80
Registered: October 2005
Location: Belgium
Member
mm_kanish05 wrote on Mon, 02 June 2008 07:35
Hi,

Im using forms 6i and I create the code like below in "when-button-pressed"


Type RecType is Table of 
	        Rpart Partmaster.partnumber%type
	        INDEX BY BINARY_INTEGER;
	    TRecType RecType; 





it should read :
Type RecType is Table of 
	        Partmaster.partnumber%type
	        INDEX BY BINARY_INTEGER;
TRecType RecType; 


you just made a pl/sql mistake
if your pl/sql table only has one column no need to use record
you can however not name that column (there's no use anyway)
Previous Topic: Unable to Run forms from Forms Builder
Next Topic: how to check for duplicates in table
Goto Forum:
  


Current Time: Sun Feb 09 09:58:43 CST 2025