Fixed. Thanks.
Tim.
On Sun, Jun 05, 2005 at 11:56:03PM +0300, Burak G?rsoy wrote:
Hello,
In the DBI pod section 'Security, especially the SQL Injection attack:'
the link http://www.webcohort.com/Blindfolded_SQL_Injection.pdf;
must be changed to either
Hello,
Has anyone made this work?
I've upgraded to unixODBC-2.2.11 with no luck (I checked the RTLGRUOP
flag and built the rpm mysql) with no luck.
I tried with a newer DBD::ODBC same result.
Any Ideas? Any info I can provide to solve this?
Thanks in advance for your help
On 06/06/2005 02:06 PM, Peter Rabbitson said:
On Mon, Jun 06, 2005 at 01:11:30PM -0700, Vergara, Michael (TEM) wrote:
I want to connect to an Oracle database and test for the existence of
a table. My first thought was to SELECT COUNT(*) FROM TABLE, but
DBI catches the ORA-942 error and I
-- Reidy, Ron [EMAIL PROTECTED]
The data dictionary is your friend ...
SELECT 'x'
FROMall_tables
WHERE table_name = UPPER(:name);
Depending on access you might be better off selecting
from user_tables: less likely to fail and the table
name is more likely to be useful in the current
Has anyone made this work?
Not us. We use DBD::Sybase and FreeTDS to connect to MS-SQL from Linux.
j
Title: SQL Parsing question
After yesterday's dummy question, I'm afraid to reveal more of my
ignorance, but here goes.
I think that this code:
$SQLstmt =
q{ alter user :DBUser identified by blarg };
print 1 Executing ,$SQLstmt, \nfor [EMAIL PROTECTED] - newpw is $pwNEWPW\n;
$SQLh
DDL and bind variables don't mix.
You have to use:
BEGIN
EXECUTE IMMEDIATE 'alter user :user identified by blarg' using 'DW'
END;
where you bind/substitute :x via the pl/sql block.
I believe you can substitute 'DW' with :user and than bind_param to the execute
immediate statement. I *think*
On Mon, Jun 06, 2005 at 11:14:06PM -0500, Tim Kirby wrote:
My situation is simple. I have an Oracle database with a simple table in it
and a query that returns maybe 25k records. I run it with sqlplus, set
pagesize to 0 and stuff the query in (client solaris, server SGI (ick)) and
whack -
On Jun 6, 2005, at 6:11 PM, Jeff Urlwin wrote:
I'd be gratefull (and you'd be happier the next release ;) if you
diagnose why Makefile.PL
detects unixODBC. I think the script is looking for $ODBCHOME/*iodbc*
or
$ODBCHOME/lib/*iodbc*. Is there a reason that your machine doesn't
detect that?
(Note: My environment- Solaris8, Perl-5.8.3 64bit, DBI-1.48 and Oracle 9.2.0
64bit)
I had a similar problem when building DBD-Oracle-1.16 . Finally solved the
problem with
the following flag on the Makefile configure step, perl Makefile.PL
-r=build64 It
seemed to have become confused on how
10 matches
Mail list logo