12-20-2009
How are you accessing the database? Via DBI? Then it shouldn't be a problem, since Perl itself uses Unicode already. Via SQL*Plus? Then you should take a look at the various NLS settings for Oracle, because sometimes it tries to convert strings for you, even if you don't want to.
Also, I think the various to_char functions can do character set conversion.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need help with a perl parsing script. I have some error logs on a windows machine that I need to parse from a text file, but I know nothing about perl. I usually run this bash script on my linux box and it does just what I need. How would I do the same thing with perl and port it to my windows... (2 Replies)
Discussion started by: cstovall
2 Replies
2. Shell Programming and Scripting
Hi,
I have searched, read and tried, but no luck.
I have this code:
#!/bin/perl -w #-d
use strict;
use POSIX qw(strftime);
my $getprpw_list="/usr/lbin/getprpw -l";
my $host = "nbsol151";
my $user = "genadmin";
my %uid;
my %spwchg;
my %upwchg;
my %slogint; (2 Replies)
Discussion started by: ejdv
2 Replies
3. Shell Programming and Scripting
Hello:
I butchered a shell script together, but my script kung-fu is 5 years old and all I've used for 5 years are for i loops. I hope that some perl guru can do in 5 minutes what takes me 5 weeks, so I am asking for help.
I have a simple script using "grep -A 2 'string' /path/to/file" but... (4 Replies)
Discussion started by: Habitual
4 Replies
4. Shell Programming and Scripting
This is the ldf file
dn: sdcsmsisdn=1000000049,sdcsDatabase=subscriberCache,dc=example,dc=com
objectClass: sdcsSubscriber
objectClass: top
postalCode: 29600
sdcsServiceLevel: 10
sdcsCustomerType: 14
givenName: Adelia
sdcsBlackListAll: FALSE
sdcsOwnerType: T-Mobile
sn: Actionteam... (1 Reply)
Discussion started by: LinuxFriend
1 Replies
5. Shell Programming and Scripting
Hi,
I have a file as below
I need to overwrite the 2 nd column alone to numeric format like "06122011030414012345" as per the timestamp value
output file should be
the microseconds can be neglected if required.
Any help will be appreciated.
Thanks in advance (1 Reply)
Discussion started by: irudayaraj
1 Replies
6. Shell Programming and Scripting
Hello Sir,
How can i convert below two loop lines in perl
for BLOCK in /sys/block/myblock*
for BLOCK in /dev/myblock*
How i can write them in perl like
foreach( </sys/block/myblock*/queue/nr_requests> ) (5 Replies)
Discussion started by: learnbash
5 Replies
7. Shell Programming and Scripting
Please tell me how to convert below program from shell script to perl. Same commands need to use in shutdown, just need program help for startup.
export ORACLE_BASE=/home/oracle1
lsnrctl start lndb1
sqlplus '/ as sysdba'
startup; (2 Replies)
Discussion started by: learnbash
2 Replies
8. Shell Programming and Scripting
Hi All,
Hope all are doing good!! Am glad that i have utilized some ideas and written a code to make the disk space result comes better and it was successfully running in the production. The next update from my manager was to make this code to come in a table format with color added.
1)... (28 Replies)
Discussion started by: Kalaihari
28 Replies
9. Shell Programming and Scripting
Hi Guys
I am having a perl script that fetches exclude list from a unix client and I trying it to convert it to shell script but I am having issues please help me...
#!/usr/bin/perl
use strict;
use warnings;
use Getopt::Std;
# To turn on debuging (i.e. more information) specify... (29 Replies)
Discussion started by: Pawan Ramnani
29 Replies
10. Solaris
Hi all!!
I´m using command file -i myfile.xml to validate XML file encoding, but it is just saying regular file . I´m expecting / looking an output as UTF8 or ANSI / ASCII
Is there command to display the files encoding?
Thank you! (2 Replies)
Discussion started by: mrreds
2 Replies
LEARN ABOUT DEBIAN
jifty::dbi::handle::oracle
Jifty::DBI::Handle::Oracle(3pm) User Contributed Perl Documentation Jifty::DBI::Handle::Oracle(3pm)
NAME
Jifty::DBI::Handle::Oracle - An oracle specific Handle object
SYNOPSIS
DESCRIPTION
This module provides a subclass of Jifty::DBI::Handle that compensates for some of the idiosyncrasies of Oracle.
METHODS
connect PARAMHASH: Driver, Database, Host, User, Password
Takes a paramhash and connects to your DBI datasource.
database_version
Returns value of ORA_OCI constant, see "Constants" in DBD::Oracle.
insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
build_dsn PARAMHASH
Takes a bunch of parameters:
Required: Driver, Database or Host/SID, Optional: Port and RequireSSL
Builds a dsn suitable for an Oracle DBI connection
blob_params column_NAME column_type
Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type. The current
Oracle implementation only supports ORA_CLOB types(112).
apply_limits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;
distinct_query STATEMENTREF
takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO
Jifty::DBI, Jifty::DBI::Handle, DBD::Oracle
perl v5.14.2 2011-04-26 Jifty::DBI::Handle::Oracle(3pm)