Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: USING RECORDS IN PS/SQL.

Re: USING RECORDS IN PS/SQL.

From: Fenella Tan <fenella_at_voicenet.com>
Date: 1997/10/24
Message-ID: <62p1kd$lkt$1@news2.voicenet.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US