Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Problem Indexing a Table ! ! !

448451Aug 29 2005 — edited Aug 29 2005
Good Morning guys,
I would like to ask something about creating associative tables. I want to create an associative table with 3 key values, something like this:

TYPE datatab IS TABLE OF mis_adeia_employee %ROWTYPE
INDEX BY NUMBER, VARCHAR2(3), DATE;
but it displays me error. Is there an alternative way? The basic reason i want to do this, is that my application which is written in PowerBuilder 7 uses datawindows, and now i try to transfer my application from PB to Oracle Forms Builder. So i try to find a structure similar to datawindows. I selected associative tables and i stacked in this example?
Any help , idea?
Thanx a lot in advance,
Regards ,
Bill ...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 26 2005
Added on Aug 29 2005
2 comments
196 views