Re: Passing TYPEs to procedures

From: Srinivas Chikka <SCHIKKA_at_worldnet.att.net>
Date: 27 Aug 1998 23:01:31 GMT
Message-ID: <6s4ogb$ri3@bgtnsc01.worldnet.att.net>

Declare this at package level so that it is available to all the package units.
>

> TYPE workrec_type IS RECORD
> (
> ACTION VARCHAR2(1),
> FACTOR NUMBER(38,16),
> RUN_ID VARCHAR2(10)
> );
>

Proc B : declaration of type : workrec_type%TYPE

Then your procedures should work..
( I haven't tested it though..)

Hope this gives enough pointers..
Srinivas.Chikka

>PROCEDURE PROCA IS
>
> TYPE workrec_type IS RECORD
> (
> ACTION VARCHAR2(1),
> FACTOR NUMBER(38,16),
> RUN_ID VARCHAR2(10)
> );
>
> work_record workrec_type;
>
>BEGIN
>
> work_record.run_id := run_id;
>
> PROCB(work_record);
>
>....
>
>END;
>-------------------
>PROCEDURE PROCB( passed_work_record IN {what do I use here???})
>IS
>
>BEGIN
>...
>END;
>
>I've tried a lot of different combinations such as:
>
>pass_work_record%workrec_type
>workrec_type%ROWTYPE
>workrec_type%TYPE
>workrec_type%RECORD
Received on Thu Aug 27 1998 - 18:01:31 CDT