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.
