Re: ORA-03117 resulting from package procedure parameter record types

Rick wrote:

> The simplest way to determine if the problem is occurring is to do the
> following in SQL Plus:
> SQL> describe test_pkg
> ERROR:
> ORA-03117: two-task save area overflow
>
> If I create a test block (without bind variables) it will actually
> execute no problem. The problem occurs when attempting to execute the
> procedure from Powerbuilder, or PL/SQL Developer or any other client
> tool that we use. Regardless, if you can do the describe, than it is
> suffice to say that you do not have the problem.

You mean this this?

SQL> desc test_pkg
PROCEDURE PROC1

  Argument Name                  Type                    In/Out Default?
  ------------------------------ ----------------------- ------ --------
  IREC_X                         RECORD                  IN
    CA_ID                        NUMBER                  IN
    PROG_REC                     RECORD                  IN
      PROG_REC                   RECORD                  IN
        PROG_ID                  NUMBER                  IN

SQL> ;-)

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)