Skip to Main Content
Forums

Oracle Database Discussions

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.

Question About Oracle 7 and Oracle 8i

303419Sep 13 2002
Dear All:

Our company bought some new Compaq alpha server run Compaq Tru64
UNIX and Oracle database server.We found the Oracle database server version is
7.3.4.0.0 and 8.1.6.2.0. Few days ago, we hear that Oracle has an official
announce which Oracle will not continue support the archived products such as Oracle 7 and Oracle 8i.



So, we have a question about the Oracle product which we bought from our SI vender. Does Oracle really has any official annonce about the support
plane for archived products.(i.e. Does Oracle has some official announce like Compaq (http://www.compaq.com/services/software/ss_pvs_se_amap.html) which describe the Prior Version Software Support Plan ?)



If Oracle has official announce about this question, please let we know. If we have this announce, we will ask our SI vender purchase latest
databse product from Oracle.


Thanks in advance!

Comments

155651
You can make use of user defined objects in Oracle 8 onwards. You can create either table of objects or varray of objects.

Mohan
395113
I am giving you an example of using array of Record


DECLARE
-- declaration of Record
TYPE REC1 IS RECORD (COLUMN1 VARCHAR2(10),
COLUMN2 DATE) ;
-- Array of Record
TYPE TAB1 IS TABLE OF REC1 INDEX BY BINARY_INTEGER ;
TAB2 TAB1 ;
-- New Procedure
PROCEDURE P1 (TAB3 TAB1) IS
BEGIN
FOR I IN 1..10 LOOP
DBMS_OUTPUT.PUT_LINE(TAB3(I).COLUMN1||'-'||TAB3(I).COLUMN2) ;
END LOOP ;
END ;

BEGIN
FOR I IN 1..10 LOOP
TAB2(I).COLUMN1 := I ;
TAB2(I).COLUMN2 := TO_DATE('23/05/2003','DD/MM/YYYY') ;
END LOOP ;

P1(TAB2) ;

EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE(SQLERRM) ;
END ;

I am assigning some values to array and passing it to an procedure and printing the value . The printing procedure
can exists separately also . Hope this solves your issue .
1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 12 2002
Added on Sep 13 2002
#general-database-discussions
3 comments
414 views