Just my opinion, but I don't think this is good advice. For
one, it creates extra administration on the system, by
forcing the user/programmer /sysadmin/webadmin to create an
ODBC DSN setting for every new setup. For two, DBI and ODBC
both support dynamic DSNs, so why not use them?
If
-- NIPP, SCOTT V \\(SBCSI\\) [EMAIL PROTECTED]
OK... I have been able to solve this problem, and it was no big
deal. However, the problem I am currently facing is really hosing me
up... Basically, a NULL field is getting converted to a 0 in the
database. This causes a comparison of
-- Rishi Bansal, Japan IT [EMAIL PROTECTED]
Hi,
I am trying to fetch data from CLOB datatype in Database.
I am getting an Error as : error:ORA-03127: no new operations allowed
until the active operation ends (DBD ERROR: OCISessionEnd).
I guess I am not handling the data fetched properly.
The code
-- Kairam, Raj [EMAIL PROTECTED]
To those who could help me with a problem connecting to an Oracle
database on HP-UX from within a perl script that uses DBI
I have a perl program on a unix (HP-UX) host(A) running Oracle 8.1.6
In the program I am trying to connect to another unix (HP-UX) host(B)
-- Reidy, Ron [EMAIL PROTECTED]
1. Programming Perl
2. Perl Cookbook
3. Object Oriented Perl
4. Extending and Embedding Perl
5. Writing CGI Applications with Perl
Watch O'Reilly Press' list for Perl Best Pratices by
Damian Conway.
--
Steven Lembark 85-09
-- Mark Stosberg [EMAIL PROTECTED]
Hello,
I have a database application that selects about 50,000 rows one by one,
does some process in Perl, and then executes a SELECT statement for each
one, with slight variations in the SQL and parameters.
I was using prepare_cached() on this repeatedly called
Basicly $StateProvince in a string value in you sql statement, so you
either single quote yourself, or let DBI do it.
Or use a placeholder and save yourself the pain of figuring
it out:
select ... where name_short = ?
will do the deed without your having to even think
about quoting.
--
Steven