Click here to get back home

how to load a picture to an oracle database with the Load a pictureto Oracle with DBI perl module

 HomeNewsGroups | Search | About
 comp.lang.perl.misc    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
how to load a picture to an oracle database with the Load a pictureto Oracle with DBI perl module Vincent Le-Texier 12-03-2004
Posted by Vincent Le-Texier on December 3, 2004, 3:37 pm
Please log in for more thread options
>>
>> [snip]
>>
>> > if I print "$1\n",
>> > the file prints just fine. But, if I do something like print "$1 after
>> > \n", the whole output is messed up. If I print "before $1\n", nothing
>> > prints at all. If I print "before $1 after\n", only after prints.
>>
>> not really sure, but could be a rogue "\r" in $1,


> There
> is a rogue carriage return (0xd) in the string

> Is there something I can do to deal with this
> situation?


Repair the corrupted file:

perl -p -i -e 'tr/\r//d' bad_file


--
Tad McClellan SGML consulting
tadmc@augustmail.com Perl programming
Fort Worth, Texas

Posted by Paul Lalli on December 3, 2004, 4:29 pm
Please log in for more thread options
>>
>> [snip]
>>
>> > if I print "$1\n",
>> > the file prints just fine. But, if I do something like print "$1 after
>> > \n", the whole output is messed up. If I print "before $1\n", nothing
>> > prints at all. If I print "before $1 after\n", only after prints.
>>
>> not really sure, but could be a rogue "\r" in $1,


> There
> is a rogue carriage return (0xd) in the string

> Is there something I can do to deal with this
> situation?


Repair the corrupted file:

perl -p -i -e 'tr/\r//d' bad_file


--
Tad McClellan SGML consulting
tadmc@augustmail.com Perl programming
Fort Worth, Texas

Similar ThreadsPosted
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/DynaLoader.pm line 230. October 14, 2005, 3:08 am
PERL Script to Load data into an oracle database August 5, 2006, 6:55 am
Need help with Perl and MySQL database data load January 14, 2005, 11:23 pm
Building DBD::Oracle with the new Oracle Express product. November 7, 2005, 12:19 pm
Using the DBI to connect to an Oracle server w/o connecting to a database December 12, 2007, 5:00 pm
Load perl module dynamically (use $object) March 5, 2006, 12:36 am
Can't install Oracle::Loader module May 2, 2005, 2:31 pm
what module could easiely load all files to a @array from a specified folder(and subfolders)? September 23, 2004, 1:02 am
Oracle 10 perl and ppm September 23, 2005, 8:42 am
Connecting to oracle from perl July 21, 2005, 11:57 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap