Using RECORD TYPE in ORACLE

Can I not refer to the 4th field in a record type as '.field4'? In a package?
I have attached a file with both package spec and body.
Rao_SAsked:
Who is Participating?
 
slightwv (䄆 Netminder) Commented:
That's because 'field4' isn't a value in the record.

you cannot reference by offset.

try:
e_message.ecc_code
0
 
Rao_SAuthor Commented:
Sorry, here is the attachement! example-msg.sql
0
 
sdstuberCommented:
if you want numeric references,  you don't want to use records

you want to use collections  (arrays)
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
sdstuberCommented:
note a collection doesn't really seem to apply for your structure though since you have 4 different data types/sizes.

A collection is all one type and size
0
 
slightwv (䄆 Netminder) Commented:
Rao_S,

Can I ask why you selected the answers you did?  Did the informational posts really help answer the question?
0
 
Rao_SAuthor Commented:
hi slightwv,
actually your post corrected my problem.
the 2 informational post only cleared a doubt in my mind (i was thinking earlier, if i should use arrays, before i posted my problem).
but your question is valid and i can change the points allocation correctly to reflect that the first solution resolved my problem.
0
 
slightwv (䄆 Netminder) Commented:
Since the first post answered the question asked and the other two confirmed a question before the question, might I suggest 250, 125, 125.
0
 
Rao_SAuthor Commented:
Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.