| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-03117 resulting from package procedure parameter record types
"Rick" <richard.kromkamp_at_contax.com> wrote:
>
>DA Morgan wrote:
>> 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)
>
>If I could see that, I would be a happy camper. In one of my tools
>(PL/SQL Developer), I've found a way around the issue, but specifying
>the "Force OCI7 mode on OCI8" connection parameter. Unfortunately, I
>can't specify anything like that in PB, so it's pretty much back to
>square one. Sounds like it's time to let the DBA's take over.
>
>Thanks for all your help.
In fact, have them ( as the error message details in the Docs indicate) contact Support ( That's why they get the big bucks)
Cause: This is an internal error message not usually issued.
Action: Contact Oracle Support Services.
 |
 |