Re: In cleanup - UNKNOWN OCI STATUS 1041 (OCILobFreeTemporary)

Bob McGowan wrote:

Ok that is great that is all I need to go on.

The copy of the

append_comments

procedure would be good as I would be able to 'test' better with it

as long as you are comfortable with sending it to me

Cheers
John Scoles

> On 05/26/2010 10:46 AM, John Scoles wrote:
>   
>> Bob McGowan wrote:
>>
>> I am interested in this  one Bob here are my words on it.
>>
>>
>>     
>
> -- Deleted my code details --
>
>   
>>>   
>>>       
>> What I want you to do so I can properly debug this is
>>
>> 1) tell me what version of DBD::Oracle you are useing
>> 2) what version of Oracle
>> 3) what platform is it running on
>> 4) what version of Perl
>>
>> finally
>> If you are using a later version of  DBD::Oracle  I would like you to
>> rerun  your code but this time do this
>>
>> $dbd->{dbd_verbose}=15;
>>
>> after you connect and then send me all the output from a test run of you
>> .PL
>>
>> cheers
>> John Scoles
>>
>>
>>     
>
> Hi, John,
>
> So far as I can tell (I'm not a PL/SQL programmer) the append_comments
> function does not explicitly create any temporary CLOB elements.  I can
> provide the code for the procedure, if you think it would help.
>
> Is it possible that the procedure needs to know it's dealing with a CLOB
> temporary element from the DBD?
>
> Here's the info you requested:
>
> 1)  DBD::Oracle is 1.24 (fyi, DBI is 1.611)
> 2)  Oracle instantclient v. 10.2.0.3, connecting to Oracle server
> 10.2.0.1.0 - 64bit
> 3)  DBD built on GNU/Linux (Debian 5.0.4), server running on a SPARC
> sun4u with Solaris OS v. 5.10
> 4)  perl v5.8.8 built for i686-linux
>
> The output for the test run is attached.
>
> Thanks again.
>
>