= $dbh-prepare(END_SQL);
DECLARE
// Not sure how to declare a varray, as I don't use them
my_varray varray;
BEGIN
my_varray := '$varray';
some_proc_call(my_varray);
END
END_SQL
HTH.
Ted Behling
-Original Message-
From: Shuxteau, Kiki [mailto:[EMAIL PROTECTED]
Sent
invoke the latter.
I'm not sure if this is an appropriate solution for smoke testing, though.
Ted Behling
-Original Message-
From: Tyler MacDonald [mailto:[EMAIL PROTECTED]
Sent: Tuesday, January 10, 2006 9:43 PM
To: dbi-users@perl.org
Subject: extra dependancies vs. testability
Sorry for replying to my own e-mail, but I had another thought. What about
just failing gracefully if SQLite2 isn't available? If it's installed, it gets
used; if not, a warning is shown and the dependent tests are skipped.
-Original Message-
From: Ted Behling
Sent: Tuesday, January
Perhaps use Schema::RDBMS::Foo. This would allow for non-RDBMS schema modules,
based on XML, DB files, or others.
-Original Message-
From: Tyler MacDonald [mailto:[EMAIL PROTECTED]
Sent: Monday, January 02, 2006 3:28 PM
To: Jay Strauss
Cc: dbi-users@perl.org
Subject: Re: Fwd: Module
Found this Web page on the topic; HTH:
http://www.arikaplan.com/oracle/ari80597b.html
Ted Behling
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 13, 2005 7:39 PM
To: List - DBI users
Subject: LongReadLen, lengthb() and Oracle
Hi Folks
The DBI
I take it the real problem is that your query is not returning any data.
Could it be that you're loading @duplist from a file, and it ends with a
newline? Try adding:
chomp $custnum;
before your execute() call.
-Original Message-
From: John [mailto:[EMAIL PROTECTED]
Sent:
Where you say WHERE custnum == ?, there ought to be only one equals sign.
Ted Behling
-Original Message-
From: John [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 11, 2005 12:40 AM
To: dbi-users@perl.org
Subject: select placeholder
Hi
Can anyone see the error in the following code
It's hard to say exactly why that's happening without seeing a snippet of your
code, but try using:
DBI::SQL_INTEGER()
In other words, add the () at the end.
-Original Message-
From: Patrick Danley [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 11, 2005 6:45 PM
To:
to find
help should you need it.
Ted Behling
-Original Message-
From: John Armstrong [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 29, 2005 8:02 PM
To: dbi-users@perl.org
Cc: cgiapp@lists.erlbaum.net
Subject: What's the best free DB for a web-based app?
Hi - I'm soon to be doing
If I remember properly, I think I saw that error when setting up
Apache::Session::Oracle. I have my A_SESSION column set up as type
LONG. I'm running 9iR2. Hope that helps.
Ted Behling
-Original Message-
From: Ron Savage [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 23, 2005 7
I like to use the DBIx::ProcedureCall module from CPAN. It provides nice
syntactic glue around the necessary DBI calls for invoking PL/SQL functions and
procedures.
Ted Behling
-Original Message-
From: logesh kumar [mailto:[EMAIL PROTECTED]
Sent: Wednesday, November 09, 2005 6:37 AM
If you really need to log into Access remotely, check out DBD::Proxy on CPAN.
Ted
-Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]
Sent: Monday, October 24, 2005 12:22 PM
To: [EMAIL PROTECTED]; dbi-users@perl.org
Subject: RE: Remote Login, using dbi:ODBC
This
I think you need to remove the semicolon at the end of the line.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Monday, October 24, 2005 2:01 PM
To: dbi-users@perl.org
Subject: Newline inserted?
I have the following sql insert statement in a file:
You appear to be using ActiveState's Perl distribution. You might have better
luck installing from CPAN, as in:
perl -MCPAN -e 'install DBD::Oracle'
Ted Behling, ISP Systems Analyst
Hargray Communications
-Original Message-
From: David Sawyer [mailto:[EMAIL PROTECTED]
Sent: Friday
attribute. I think this might involve just a simple
addition to DBI::connect().
Ted Behling, ISP Systems Analyst
Hargray Communications
[EMAIL PROTECTED]
15 matches
Mail list logo