RE: Question that may not have an answer

You can keep the data in CSV format and use DBD::CSV to access the data. http://search.cpan.org/~jzucker/DBD-CSV-0.22/lib/DBD/CSV.pm Anna Q. Fong, Chief Phone: (916) 574-2632 Flood Operations, Decision Suppo

RE: Duplicate table structure

Export from database 1 Import into database 2 Truncate table in database 2 -Original Message- From: Peter Scott [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 06, 2007 2:38 PM To: dbi-users@perl.org Subject: Duplicate table structure Is there a simple way to create a new table with t

RE: DBI Make Error on HP-UX

Looks like you tried to compile DBI using the brain-dead C compiler that comes with HP-UX. Buy and download the ANSI C version from HP. Anna Q. Fong, Acting Chief Phone: (916) 574-2632 Flood Operations, Decision S

RE: Order by statement stopped working but not in all cases

I could not find the underlying reason why this query no longer worked as expected, but have modified each of the affected applications to work around the issue. I'll keep my fingers crossed... Anna -Original Message- From: Ron Savage [mailto:[EMAIL PROTECTED] Sent: Friday, January

RE: Order by statement stopped working but not in all cases

de to the Oracle system software -Original Message- From: Andy Hassall [mailto:[EMAIL PROTECTED] Sent: Friday, January 20, 2006 12:39 PM To: Fong, Anna; dbi-users@perl.org Subject: RE: Order by statement stopped working but not in all cases Do you have error handling on the statemen

RE: Order by statement stopped working but not in all cases

Yes, and it works as expected in SQLPLUS with no modifications to the original query. One thought was the sort space, but this instance doesn't support it. -Original Message- From: Kong, Alan [mailto:[EMAIL PROTECTED] Sent: Friday, January 20, 2006 10:27 AM To: Fong, Anna Subjec

Order by statement stopped working but not in all cases

Has anyone ever heard of this? What do you think might be the cause and importantly, the solution? We have a bunch of applications that use DBI and DBD-Oracle and they've been running for quite some time now (months and years, depending on which app). Then within the last few days, one particul

RE: How to store query results in an array?

Daniel, Why not use a subquery? It'll be more efficient than using the array. Something like "SELECT * FROM ... WHERE ... IN (SELECT ...)"; HTH, Anna -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 25, 2005 11:40 AM To: dbi-users@perl.org

RE: Killing a Process

If your Oracle DBA has a resource profile set for your web server user, you can set parameter IDLE_TIME. How to create a profile -- http://www.adp-gmbh.ch/ora/sql/create_profile.html -Original Message- From: Kevin Bass [mailto:[EMAIL PROTECTED] Sent: Sunday, November 21, 2004 4:53 AM To

RE: Apache, DBI, Oracle

In your Apache error_log, it will give you the nature of the server error which will help you to troubleshoot whether it's a permissions problem, browser problem, or some other issue. In your script, make sure you have the "Content-type" statement if you plan to output to a browser. This is no

RE: Query

Be sure to use bind parameters for the args and set up the query so that there is a defined universe of choices. See an example of one of my apps -- http://cdec.water.ca.gov/cgi-progs/staSearch What I did was set up separate parameters for each checkbox (and of course, separate parameters for ea

RE: Hello

Can this be stopped at the network or at the server from perl.org's end of things? The only source of mydoom virus coming to me is from the dbi list. Our network here aleady stops all other sources, but since I have the dbi list as a "trusted" source... -Original Message- From: Hardy

RE: Query formatting problem

ty, a companion method to $sth->dump_results called $sth->dump_query? -Original Message- From: Steven Lembark [mailto:[EMAIL PROTECTED] Sent: Thursday, June 12, 2003 2:40 PM To: Fong, Anna Subject: RE: Query formatting problem -- "Fong, Anna" <[EMAIL PROTECTED]>

RE: question: DBD::Oracle needed for DBI on another host?

Janet, Add an alias entry on your client's (DEC Alpha) tnsnames.ora file for the other Oracle database. Then use the new alias in your connect string. Hope this helps, Anna Anna Q. Fong, Webmaster California Data Exchange Center > --

RE: Perl DBI and Perl CGI headers

This is a perl CGI question, not a DBI question. Consider using [EMAIL PROTECTED] Anna Q. Fong, Webmaster California Data Exchange Center > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Friday, Ja

RE: Using DBI/Oracle stand alone

Cyril, I'm not sure why you'd need to have DBI compiled on each of your servers -- you can change the db connect string to access your Oracle databases from one location over TCP/IP. Just set up the proper entries in your tnsnames.ora file --

Re: Oracle Group By statement

Group by fiscal_yr (actual_date) HTH, Steve Anna Q. Fong, Webmaster California Data Exchange Center > -Original Message- > From: Michael A Chase [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, November 14, 2002 1:22 PM > To: [EMAIL

RE: Oracle Group By statement

Clarification: What I'm trying to do is more akin to fiscal year, say from Oct to Sep. For quarter, Steve Baldwin's answer works great! > -Original Message- > From: Steve Baldwin [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, November 14, 2002 12:12 PM > To: Fong,

OT: Oracle Group By statement

Can anyone point me to the answer? I want to use an arbitrary group in the group by statement. I can group by year but want to change the calendar year to another unit of measure such as quarter. This works: select to_char(actual_date,''), sum(value) from daily_data where sensor_id=?

RE: Trying to get LIKE to work

Assuming you have a SID of MYDB, you would find the initMYDB.ora in $ORACLE_BASE/admin/MYDB/pfile/ Anna Q. Fong, Webmaster California Data Exchange Center > -Original Message- > From: Kipp, James [SMTP:[EMAIL PROTECTED]] > Sen

dumping from Oracle DB to XML

Does anyone know of an easy way to dump Oracle tables to XML? Thanks for your reply, Anna Anna Q. Fong, Webmaster California Data Exchange Center