Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: USING RECORDS IN PS/SQL.
Internal Error usually happens when you forget the %TYPE attribute when declaring variables and parameters. so in package p2, you have to say : miRecordVar P1.t_miRecord%TYPE.
To assign values to records :
miRecordVar.val1 := 1;
miRecordVar.val2 := 'Good Morning'
etc..
You can also assign the a record to another record of the same recordtype. Received on Fri Oct 24 1997 - 00:00:00 CDT
![]() |
![]() |