Pl/sql Table problem [message #324323] |
Mon, 02 June 2008 00:35  |
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 #326469 is a reply to message #324323] |
Wed, 11 June 2008 10:29  |
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)
|
|
|