Q
Problem solve Get help with specific problems with your technologies, process and projects.

New user error

I've got a problem with the creation of:

TYPE user_rec IS RECORD
(id     UTILISATEUR.idutilisateur%TYPE,
 idtypeus UTILISATEUR.idtypeuser%TYPE,
 nom        UTILISATEUR.nom%TYPE,
 prenom     UTILISATEUR.prenom%TYPE,
 adresse    UTILISATEUR.adresse%TYPE );
	   
 TYPE t_row IS TABLE OF user_rec;

When I try to use it like this:

New_User T_ROW := T_ROW();
BEGIN
   New_User.EXTEND (1);
-> New_User(0).id       := i_iduser;
   New_User(0).idtypeus := i_idtypeuser;
   New_User(0).nom      := i_nom;
   New_User(0).prenom   := i_prenom;
   New_User(0).adresse  := i_adresse;

I received this message:

ORA-06532: Indice hors limites
Remove the '(0)' from your assignment statements. Try the following instead:

New_user.id := i_iduser;

This was last published in March 2004

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close