NLS_LANG = en_GB.UTF-8
As I understand it, "UTF-8" is not a valid charset. It needs to be
either AL32UTF8, or UTF8 (no dash). There is a difference between the
two, and you probably want AL32UTF8, but I recommend researching the
difference.
I know you said you tried changing this value, so this
The 20,000 character default is hardcoded in the DBD::Oracle
implementation of dbms_output_enable. I don't see a way around it
with the current implementation.
But as a workaround, you could probably replace your use of
dbms_output_enable with:
$dbh->do("begin dbms_output.enable(NULL); end;");
O
Unless this is not an exact copy, there appears to be a bug in your
code. You are missing a comma between "$packetCard" and "{ ORA_TYPE
=> ORA_RAW }", as well as in a few other places.
Adding that comma may fix it. If not, I am not seeing any difference
in DBD::Oracle's handling between ORA_RAW
nking. Mostly I just know
about how to get DBI to interact with MySQL.
I should mention that I'd also like to be able to make some rules in
the "real" database temporarily disappear while testing, but I fear
this will make things even more complicated.
On 7/19/07, Sven Miller <[
I would consider setting up the test database to consist of a database
link to the "real" database, along with views for all the tables.
Then on those tables where I wanted to interject some data, I would
create test-data tables and alter the views to merge the data.
Then switching from "test" to
Sounds like you want:
$esc = $dbh->get_info( 14 ); # SQL_SEARCH_PATTERN_ESCAPE
$user_input =~ s/([_%])/$esc$1/g;
$search_pattern = '%' . $user_input . '%';
$sth->execute( $search_pattern );
On 6/29/07, Bill Moseley <[EMAIL PROTECTED]> wrote:
On Fri, Jun 29, 2007 at 04:01:25PM +0100, Raf wrote:
(DBD::Oracle version 1.17)
Given the following:
my $sLobLocator;
my $hSQL = $hDB->prepare(q{
BEGIN
:lob := NULL;
END;
}, { ora_auto_lob => 0 });
$hSQL->bind_param_inout( ':lob', \$sLobLocator, 0, { ora_type => ORA_BLOB } );
$hSQL->execute;
print "\$sLobLocator = $sLobLocator\n";
print "\$\$
I'm trying to determine which function I should use for reading BLOB
data from an Oracle database: blob_read() or ora_lob_read().
Version 1.0 added support for blob_read() back in 1999. The function
is never officially documented anywhere, and the Oraperl documentation
still calls it "experiment