• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 227
  • Last Modified:

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.
0
Rao_S
Asked:
Rao_S
  • 3
  • 3
  • 2
3 Solutions
 
Rao_SAuthor Commented:
Sorry, here is the attachement! example-msg.sql
0
 
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
 
sdstuberCommented:
if you want numeric references,  you don't want to use records

you want to use collections  (arrays)
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now