Is it possible with Latest DBI modules to pass an array [string or
integer] to Oracle stored procedure which accepts an array?
Procedure specification is like this:
Create or replace procedure p_getarray_perl(p_arr_value
dbms_sql.varchar2_table) -- String array.
How do I pass an array
fourni.
Subject: Arrays to Oracle Stored Procedures
Date: Tue, 19 May 2009 11:48:52 -0400
From: srikanth.turlap...@ky.gov
To: dbi-users@perl.org
Is it possible with Latest DBI modules to pass an array [string or
integer] to Oracle stored procedure which accepts an array?
Procedure
, Srikanth (Education Cabinet); dbi-users@perl.org
Subject: RE: Arrays to Oracle Stored Procedures
--you can pass in a huge string then in your Oracle Procedure
--then split the pieces by known delimiter
--Here is an Oracle Procedure which uses a Oracle array type to refer to HUGE
varchar2
I've been trying to come up with a consistent and comfortable approach
to dealing with a large number of complex action-performing stored
procedures I've got sitting in my Oracle database -- things with names
like Assign_customer that perform many actions across several tables
and don't
Greetings.
Is there a driver-neutral way of executing a stored procedure and
fetching a recordset from it?
I've noticed some documentation for binding input variables with Oracle.
I've also noticed I can call a procedure by name ( and list the input
variables after the procedure name ) when I
Windows 2000
Active State Perl 5.6.1.638
DBI 1.37
DBD::Pg 0.95 - this is the only win32 binary I have been able to find
I would like to be able to execute a pgsql stored procedure from within
my perl program and retrieve the return value.
So far as I have been able to determine, that is not
Hello all,
Am a newbie to SQL Server and the DBI interface and could use some help.
I'm able connect to MSSQL via DBD::Sybase.
And am able to run a stored procedure (with hard coded values that are
inserted into a table).
Now, how would I pass values (approximately 30) to this stored
The DBD::Oracle docs cover how to call stored procedures.
However, if you have stored procedures that generate web pages via the
mod_plsql web toolkit functions/procedures in the htp/htf packages, you should
be using the mod_plsql gateway to execute them. Those functions/procedures
.
-Original Message-
From: Kevin Moore [mailto:[EMAIL PROTECTED]
Sent: Monday, May 09, 2005 10:32 PM
To: 'dbi-users@perl.org'
Subject: Executing Oracle stored procedures
All,
I've got Apache v2.x, Oracle 9i, running on Red Hat linux 9, mod_perl,
and DBI installed and working. I'd like
All,
I've got Apache v2.x, Oracle 9i, running on Red Hat linux 9, mod_perl,
and DBI installed and working. I'd like to be able to execute Oracle
stored procedures. Is anyone doing this without the mod_plsql plugin? If
so, would you be wlling to share tips for making this work.
I've already
On 04/22/2005 09:30 AM, Denesa K Shaw said:
How do I pass an one parameter to a External Stored Procedure?
I don't think anyone here has a clue. Without knowing what DBD driver
you are using, the answer would be pure guesswork. Please read the URL
in my signature.
If you have a DBI 1.38 or
How do I pass an one parameter to a External Stored Procedure?
Hi all,
This is probably a dumb question, but how do I run stored procedures with the
DBI? I am using DBD::ODBC.
Regards,
Javier Moreno
On Tue, 1 Mar 2005 11:49:40 -0600, Moreno, Javier
[EMAIL PROTECTED] wrote:
Hi all,
This is probably a dumb question, but how do I run stored procedures with the
DBI? I am using DBD::ODBC.
my $dbh = DBI-connect(dbi:ODBC:server, 'name', 'password');
my $query = exec spTest ;
my $sth = $dbh
Quoting Moreno, Javier [EMAIL PROTECTED]:
This is probably a dumb question, but how do I run stored procedures with
the DBI? I am using DBD::ODBC.
It's pretty low level, but you may find some of the links in the perldoc useful.
http://search.cpan.org/~jurl/DBD-ODBC/ODBC.pm
A Google search
From: Brian Roy [EMAIL PROTECTED]
Date: 2005/03/01 Tue PM 12:28:50 CST
If anyone is willing to chime in on how to pull out OUTPUT params I
would love to have an example. I just gave up getting it to work.
This is from the first hit on a googling of 'perl dbi stored procedures
output
explain
how to get output parameters and procedure return values.
Martin
Quoting Brian Roy [EMAIL PROTECTED]:
On Tue, 1 Mar 2005 11:49:40 -0600, Moreno, Javier
[EMAIL PROTECTED] wrote:
Hi all,
This is probably a dumb question, but how do I run stored procedures with
the DBI? I am using DBD
On Tue, 1 Mar 2005 11:49:40 -0600, Moreno, Javier
[EMAIL PROTECTED] wrote:
Hi all,
This is probably a dumb question, but how do I run stored
procedures
with the DBI? I am using DBD::ODBC.
my $dbh = DBI-connect(dbi:ODBC:server, 'name',
'password'); my $query = exec spTest
]:
On Tue, 1 Mar 2005 11:49:40 -0600, Moreno, Javier
[EMAIL PROTECTED] wrote:
Hi all,
This is probably a dumb question, but how do I run stored procedures
with
the DBI? I am using DBD::ODBC.
my $dbh = DBI-connect(dbi:ODBC:server, 'name', 'password');
my $query = exec spTest
Hi all,
Trying to solve a puzzle -- how to write a cross-platform code to call
stored procedure with output parameters and return codes.
Environment:
- MS SQL 2000 database
- Win32, ActivePerl - 5.8.6, DBD::ODBC
- Linux, perl 5.8.0, DBD::Sybase (freeTDS)
Stored procedure:
Placeholders are only supported for values in select
statements. For your exec, you will need to substitute
in values with perl variables.
That's the essence of the error message.
regards,
David
--- [EMAIL PROTECTED] wrote:
Hi all,
Trying to solve a puzzle -- how to write a
cross-platform
To
dbi-users@perl.org
cc
Subject
[Spam: 05.3] Re: DBD::ODBC, DBD::Sybase and parameters to stored
procedures
Placeholders are only supported for values in select
statements. For your exec, you will need to substitute
in values with perl variables.
That's the essence of the error message
returning
utf8 strings from Oracle via stored procedures and there is a problem
with my set-up? Or have I stumbled upon something else?
An example of my test script is below.
(I'm in the process of upgrading from Oracle 8i and DBD::Oracle 1.12)
Thanks,
Alan
#!/usr/bin
to.
Are there other users with similiar set-ups successfully returning
utf8 strings from Oracle via stored procedures and there is a problem
with my set-up? Or have I stumbled upon something else?
An example of my test script is below.
(I'm in the process of upgrading from Oracle 8i and DBD::Oracle
successfully returning
utf8 strings from Oracle via stored procedures and there is a problem
with my set-up? Or have I stumbled upon something else?
I do not think it is a problem with your setup.
I have the same situation here (Oracle 9i , Perl 5.8.5 , DBD::Oracle
1.15).
Thilo
module to turn the flag on, but
of course I would rather not have to.
Are there other users with similiar set-ups successfully returning
utf8 strings from Oracle via stored procedures and there is a problem
with my set-up? Or have I stumbled upon something else?
An example of my test script
Hi,
I'm calling a stored procedure called Pg_Move_Files.Pr_Return_Cycle_File.
After the stored procedure executes, it returns an out parameter called
out_v_RECV_FILE_NM.
I have a perl script which uses the DBI:: Module.
My Question is:
Is the correct way retrieve the value of my out
There are examples in the DBD::Oracle docs.
-
Ron Reidy
Lead DBA
Array BioPharma, Inc.
-Original Message-
From: Denesa K Shaw [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 20, 2004 2:28 PM
To: [EMAIL PROTECTED]
Subject: Stored Procedures Parameters
Hi,
I'm
perldoc DBD::Oracle will show you how to do this.
On Wed, 2004-10-20 at 15:27, Denesa K Shaw wrote:
Hi,
I'm calling a stored procedure called Pg_Move_Files.Pr_Return_Cycle_File.
After the stored procedure executes, it returns an out parameter called
out_v_RECV_FILE_NM.
I have a perl
Sorry, I am assuming you are using Oracle, are you?
Look for bind_paraminout().
On Thu, 2004-10-21 at 08:34, Scott T. Hildreth wrote:
perldoc DBD::Oracle will show you how to do this.
On Wed, 2004-10-20 at 15:27, Denesa K Shaw wrote:
Hi,
I'm calling a stored procedure called
...bind_param_inout(), typo.
On Thu, 2004-10-21 at 08:36, Scott T. Hildreth wrote:
Sorry, I am assuming you are using Oracle, are you?
Look for bind_paraminout().
On Thu, 2004-10-21 at 08:34, Scott T. Hildreth wrote:
perldoc DBD::Oracle will show you how to do this.
On Wed,
.
HildrethTo: Denesa K Shaw [EMAIL
PROTECTED]
[EMAIL PROTECTED] cc: [EMAIL PROTECTED] [EMAIL
PROTECTED]
tgroup.com Subject: Re: Stored
Subject: Re: Stored Procedures
Parameters
10/21/2004 08:36
:
10/21/2004 09:13 AM Subject: RE: Stored Procedures
Parameters
I am thinking of making a significant design change to my
SQL::SyntaxModel / Rosetta modules within the next week or so, but I
am debating whether it would be an improvement or a step backwards.
This change would be mostly to data, rather than code, because the
modules are heavily data-driven.
Darren, and anyone replying, please don't cross-post to [EMAIL PROTECTED]
with topics not directly related to the DBI or drivers.
Thnaks.
Tim.
Folks,
I have tried to use many different combinations of trying to
call a DB2
stored procedure through a cgi script but this is what I see
in the error
logs, [Fri Aug 20 10:46:56 2004] mail2_form.pl:
DBD::ODBC::st execute
failed: [IBM][CLI Driver][DB2] SQL0440N No function by
Folks,
I have tried to use many different combinations of trying to call a DB2
stored procedure through a cgi script but this is what I see in the error
logs, [Fri Aug 20 10:46:56 2004] mail2_form.pl: DBD::ODBC::st execute
failed: [IBM][CLI Driver][DB2] SQL0440N No function by the name
Folks,
I am not sure if this has been answered before or not but on searching the
list archives I haven't been able to get an answer. I am connecting to DB2
using DBD::ODBC and am also able to run select statements. Now I have to
run a stored procedure through the connection and was wondering
I am trying to run an MS SQL server stored procedure using Perl.
We are using SQL Server 2000. Using the current Perl and DBI.
Can I use the ODBC DBD?
I am using a prepare,execute and fetch.
Has anyone tried this and do you have examples or how to do this?
I use the 'exec' command but get syntax
From: [EMAIL PROTECTED] (PerlDiscuss - Perl Newsgroups and mailing lists)
I am trying to run an MS SQL server stored procedure using Perl.
We are using SQL Server 2000. Using the current Perl and DBI.
Can I use the ODBC DBD?
I am using a prepare,execute and fetch.
Has anyone tried this and do
Tim,
Oracle 8.1.7
DBI 1.28
DBD::Oracle 1.12
I hope this email does not irriatate you but I really need some help. I have an Oracle
DBA I need to work with who doesn't seem to how to write PL/SQL for Perl DBI. He
insists on writting stored procedures which loop through the results set
On 02/04/2004 06:56 AM, Michael Cesar wrote:
Oracle 8.1.7
DBI 1.28
DBD::Oracle 1.12
I hope this email does not irriatate you but I really need some help.
I have an Oracle DBA I need to work with who doesn't seem to how to
write PL/SQL for Perl DBI. He insists on writting stored procedures
which
On 02/04/2004 12:55 PM, Michael Cesar wrote:
Heres the entire script.
Michael Cesar
#!/usr/local/bin/perl -w
use strict;
use DBI;
use Data::Dumper;
use DBD::Oracle qw(:ora_types);
my (@result_arref,@row);
my $dbh = DBI-connect(
'dbi:Oracle:XXX',
'abc',
On 02/04/2004 06:09 PM, Michael Cesar wrote:
Thanks a million...
BTW, if you are really putting the SELECT text in the script,
prepare()ing a SELECT by itself and executing that would be more
efficient and avoids having a cursor returned from a package.
Why is this so? My DBA wants everything
Hello,
I am using DBI v. 1.38, DBD::Sybase v. 1.01 (?), and FreeTDS 0.61.2 to
connect to an MSSQL 6.5 database from a Linux client and I am having
problems retrieving the values of out parameters to a stored procedure
call.
I followed the example in the DBD::Sybase docs modifying for my purpose
Steven,
I believe that you are misunderstanding what it is that you are
receiving. The only output from your commands is the print @c. This
comes through the error handler since a print statement is a level 0 or
level 10 message from the server and not a result set. Try changing the
print
: [EMAIL PROTECTED]
Subject: Re: Stored procedures and DBD::Sybase
Steven,
I believe that you are misunderstanding what it is that you are
receiving. The only output from your commands is the print @c. This
comes through the error handler since a print statement is a level 0 or
level 10
On Mon, 2003-11-10 at 06:30, Steven Velez wrote:
Hello,
I am using DBI v. 1.38, DBD::Sybase v. 1.01 (?), and FreeTDS 0.61.2 to
connect to an MSSQL 6.5 database from a Linux client and I am having
problems retrieving the values of out parameters to a stored procedure
call.
MS-SQL doesn't
- Forwarded message from Grimes, Greg [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
Subject: Pass Arrays to Stored Procedures in Oracle
Date: Wed, 13 Aug 2003 14:28:38 -0500
From: Grimes, Greg [EMAIL PROTECTED]
To: [EMAIL PROTECTED], Steve Baldwin [EMAIL PROTECTED]
X
Hi all,
I have a stored procedure that returns an array. Here is the PROC
definition:
TYPE tab_num10 is TABLE of
NUMBER(10)
INDEX BY BINARY_INTEGER;
--
--
PROCEDURE Add_Device(
p_IPAddress in varchar2,
p_DeviceType in varchar2,
p_DeviceID OUT Device_Management.tab_num10);
I have tried the
On Tue, Mar 11, 2003 at 03:54:34AM -0800, N, PraveenX wrote:
Hi,
I am using PERL version 5.6. One of the applications developed needs data in
arrays to be passed as arguments to stored procedure in Oracle 8i.
You still haven't told us the versions of DBI and DBD::Oracle that you are
On Monday, January 13, 2003, at 11:03 AM, Jeff Boes wrote:
My problem is that for such procedures, doing:
select fn_stored_proc(id_field) from table_name;
opens and closes the database connection over and over. This is very
inefficient. Is there some way to inherit the connection so it
Hi,
I have a problem with PERL and the stored procedures.
I can't execute
my $sth_proc = $dbh-prepare(call
db2inst1.sert_resource(?,3,?,?,?,?));
$sth_proc-bind_param(1,$LOG IN_NAME);
$sth_proc-bind_param(2,$cpu);
$sth_proc-bind_param(3,$macc);
$sth_proc-bind_param(4,$anno);
$sth_proc
Has anyone here done any work with PostgreSQL stored procedures which
themselves use DBI? Essentially, I've got a stored procedure that looks
like ...
CREATE FUNCTION fn_stored_proc(integer) as '
use DBI;
my $dbh = DBI-connect(...);
my $sth = $dbh-prepare(...);
$sth-execute
20, 2002 11:06 AM
To: [EMAIL PROTECTED]
Subject: Re: Stored Procedures with DBD::Sybase and FreeTDS
On Thu, 2002-12-19 at 13:35, [EMAIL PROTECTED] wrote:
Has anyone had a problem calling to a stored procedure that performs an
insert and returns no data ?
I am currently having
Has anyone had a problem calling to a stored procedure that performs an
insert and returns no data ?
I am currently having that and the error that I am getting is:
dbih_setup_fbav: invalid number of fields: 0, NUM_OF_FIELDS attribute
probably not set right at
On Thu, 2002-12-19 at 13:35, [EMAIL PROTECTED] wrote:
Has anyone had a problem calling to a stored procedure that performs an
insert and returns no data ?
I am currently having that and the error that I am getting is:
dbih_setup_fbav: invalid number of fields: 0, NUM_OF_FIELDS attribute
ones. You can use placeholders if you
wish.
Tim Vorce
Ford Motor Company
[EMAIL PROTECTED]
-Original Message-
From: Zhao, Charles [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 4:50 PM
To: [EMAIL PROTECTED]
Subject: RE: Perl DBI and Stored Procedures
Thanks for all
output ones. You can use
placeholders if you wish.
Tim Vorce
Ford Motor Company
[EMAIL PROTECTED]
-Original Message-
From: Zhao, Charles [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 4:50 PM
To: [EMAIL PROTECTED]
Subject: RE: Perl DBI and Stored Procedures
Thanks for all
Have you tried this?
$sth = $dbh-prepare(exec $database..storedProcedure $parm);
On Thu 2002/12/19 10:12:11 PST, Zhao, Charles [EMAIL PROTECTED] writes
:
$database is the name of the database, as it is not included in the =
data
source name. On my $server there are dozens of databases so
error in the statement preparation.
Any ideas what's wrong with the above?
Thanks a lot.
-Original Message-
From: Brien Pirkle [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 05, 2002 12:38 AM
To: 'Zhao, Charles '; '[EMAIL PROTECTED] '
Subject: RE: Perl DBI and Stored Procedures
, December 12, 2002 11:23 AM
To: [EMAIL PROTECTED]
Subject: calling oracle stored procedures using DBI
- URGENT
Hi,
I have a stored procedure which returns an Oracle
OBJECT. This object contains a list of objects,
which
inturn contain the table. I would like to read a
column from this table
On Thu, 12 Dec 2002 16:20:21 -0800 (PST) Nanditha Gade [EMAIL PROTECTED] wrote:
Thanks for the info. But i have a restriction that i
can't create procedures on the database...
You can do the conversion in an anonymous block that assigns the values to
bind variables.
DECLARE
o1 object;
I need to call stored procedures directly from Perl -- don't want to use
any shell script in between. Can anybody please give me any tips how to
do it?
Thanks.
On Wed, 4 Dec 2002 15:27:02 -0800 Zhao, Charles [EMAIL PROTECTED] wrote:
I need to call stored procedures directly from Perl -- don't want to use
any shell script in between. Can anybody please give me any tips how to
do it?
RTFM: http://xmlproj.com/fom-serve/cache/49.html
For any more
Sybase sql servers is what I am using. So far every reply has been very
helpful.
Thanks.
-Original Message-
From: Michael A Chase [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 4:03 PM
To: [EMAIL PROTECTED]; Zhao, Charles
Subject: Re: Perl DBI and Stored Procedures
On Wed, 2002-12-04 at 16:13, Zhao, Charles wrote:
Sybase sql servers is what I am using. So far every reply has been very
helpful.
There's nothing magic about executing stored procedures with
DBD::Sybase. You can run them like any other SQL statement.
Michael
-Original Message
Roger,
Thank you v. much. This is exactly the info I was looking for.
Rgds,
Brien
-Original Message-
From: Roger Perttu
To: Brien Pirkle; '[EMAIL PROTECTED] '
Sent: 28/11/02 16:47
Subject: Re: Calling SQLServer Stored Procedures
Brien Pirkle wrote:
Jeff,
So, assuming sp_foo takes
How can I execute a SQL Server stored proc from my Perl script? The Cheeta
book (DBD::ODBC Driver pg 296) suggests using the following ODBC escape
sequence:
{call procedure1_name}
Fine. But what's the rest of the syntax?
My platform is NT, ActivePerl 633...database is SQLServer2000.
TIA,
Brien Pirkle wrote:
How can I execute a SQL Server stored proc from my Perl script? The Cheeta
book (DBD::ODBC Driver pg 296) suggests using the following ODBC escape
sequence:
{call procedure1_name}
Fine. But what's the rest of the syntax?
From BOL:
The ODBC CALL escape sequence for
How can I execute a SQL Server stored proc from my Perl script?
The Cheeta
book (DBD::ODBC Driver pg 296) suggests using the following ODBC escape
sequence:
{call procedure1_name}
Fine. But what's the rest of the syntax?
Err, that is the syntax. If your procedure name is sp_foo,
-Original Message-
From: Jeff Urlwin
To: Brien Pirkle; [EMAIL PROTECTED]
Sent: 28/11/02 14:55
Subject: RE: Calling SQLServer Stored Procedures
How can I execute a SQL Server stored proc from my Perl script?
The Cheeta
book (DBD::ODBC Driver pg 296) suggests using the following ODBC
Brien Pirkle wrote:
Jeff,
So, assuming sp_foo takes no paramters, my whole script could be:
#
use DBI;
my $dbh = DBI-connect('DBI:ODBC:OSTDB', 'user', 'password')
or die Couldn't connect to database: . DBI-errstr;
{call sp_foo}
#More like this:
my
All,
Having difficulty with an error message no statement executing against the
following
my $dbh = DBI-connect($DATA_SOURCE,$USER,$PASSWORD,{AutoCommit = 0,
RaiseError = 0, PrintError = 0 }) or error(Can`t connect to db:
DBI::errstr, 1,2);
# DBI-trace(2);
my $sth =
Having difficulty with an error message no statement executing
against the
following
my $dbh = DBI-connect($DATA_SOURCE,$USER,$PASSWORD,{AutoCommit = 0,
RaiseError = 0, PrintError = 0 }) or error(Can`t connect to db:
DBI::errstr, 1,2);
# DBI-trace(2);
my $sth =
://www.mbay.net/~mpeppler
[EMAIL PROTECTED] / ZetaTools, Inc / http://www.zetatools.com
ZetaTools: Call perl functions as Sybase stored procedures!
signature.asc
Description: This is a digitally signed message part
://www.mbay.net/~mpeppler
[EMAIL PROTECTED] / ZetaTools, Inc / http://www.zetatools.com
ZetaTools: Call perl functions as Sybase stored procedures!
signature.asc
Description: This is a digitally signed message part
: RE: Problem with stored procedures with inserts.
Ok -- I have a quick fix for this which I'll release shortly. I still need
to look into a few other bugs. This may not be a complete fix, but it seems
to resolve the issues. I plan on making a SQLServer specific set of tests
that add
I am having a problem with a script after upgrading the DBD::ODBC
the script
was running from version 0.28 to 0.45.8. I am getting invalid cursor state
errors on stored procedures that contain insert queries. This is using MS
SQL 7.0, Activestate Perl 5.6.1 bild 631. Is there something
-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 29, 2002 10:48 AM
To: Sthoward; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Problem with stored procedures with inserts.
I am having a problem with a script after upgrading the DBD::ODBC
the script
was running from
]]
Sent: Monday, July 29, 2002 10:48 AM
To: Sthoward; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: RE: Problem with stored procedures with inserts.
I am having a problem with a script after upgrading the DBD::ODBC
the script
was running from version 0.28 to 0.45.8. I am getting invalid
From: T. Murlidharan Nair [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 19, 2002 12:57 PM
Subject: Stored procedures and Perl DBI
Has anyone executed a stored procedures from a perl CGI. I am having
problems when there are many rows returned. When the return result
Folks,
I'm in the process of redesigning a web-based interface for a database
driven website. The previous iteration of this system had SQL queries
embedded within the scripts themselves. In the second version, I'd like
to use stored procedures to streamline the database transactions
a web-based interface for a database
driven website. The previous iteration of this system had SQL queries
embedded within the scripts themselves. In the second version, I'd like
to use stored procedures to streamline the database transactions.
Unfortunately, I've come up short on resources
From: Sean Culhane [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 16, 2002 21:08
Subject: Executing stored procedures
I'm in the process of redesigning a web-based interface for a database
driven website. The previous iteration of this system had SQL queries
embedded within
]
List-Subscribe: mailto:[EMAIL PROTECTED]
Delivered-To: mailing list [EMAIL PROTECTED]
Date: Fri, 5 Apr 2002 09:55:43 +0100 (BST)
From: Ben Lowe - RMC EMEA - Web Developer [EMAIL PROTECTED]
Subject: DBD::Proxy connecting to Oracle using PL/SQL and stored procedures
To: [EMAIL PROTECTED]
Hello
[EMAIL PROTECTED]
Date: Fri, 5 Apr 2002 09:55:43 +0100 (BST)
From: Ben Lowe - RMC EMEA - Web Developer [EMAIL PROTECTED]
Subject: DBD::Proxy connecting to Oracle using PL/SQL and stored procedures
To: [EMAIL PROTECTED]
Hello,
This is my first post to this list. I need to be able to run PL/SQL
Hello,
This is my first post to this list. I need to be able to run PL/SQL and
oracle stored procedures using the perl DBI. I am using the DBD::Proxy
driver to connect to the oracle server on another host. I cannot get
the following simple code to work.
my $p1;
my $csr = $dbh-prepare(q
On 2 Apr 2002 at 12:51, [EMAIL PROTECTED] wrote:
Where I work, we use a lot (thousands) of Sybase stored procedures and
have only recently adopted DBI and DBD::Sybase. Is there any
DBIx-type module out there that handles fetching the return status and
output params in an intuitive way
On 2 Apr 2002 at 19:43, Tim Bunce wrote:
[EMAIL PROTECTED] wrote:
I have a proof-of-concept module that does this, tentatively called
DBIx::Sybase::StoredProc,
I'd suggest just Sybase::StoredProc
Why doesn't this fit into the DBIx namespace, in your opinion? Just
curious.
-Tim
On Thu, Apr 04, 2002 at 12:22:34PM +0100, Tim Noll wrote:
On 2 Apr 2002 at 19:43, Tim Bunce wrote:
[EMAIL PROTECTED] wrote:
I have a proof-of-concept module that does this, tentatively called
DBIx::Sybase::StoredProc,
I'd suggest just Sybase::StoredProc
Why doesn't this fit
.
Does inserting a return statement make the script fail for you?
Thanks.
-John
[EMAIL PROTECTED] on 04/02/2002 02:55:54 PM
To: Michael Peppler [EMAIL PROTECTED]
cc: [EMAIL PROTECTED] (bcc: John Tobey/Intdata)
Subject: Re: Sybase stored procedures
Michael Peppler [EMAIL PROTECTED
Hi all,
Where I work, we use a lot (thousands) of Sybase stored procedures and have only
recently adopted DBI and DBD::Sybase. Is there any DBIx-type module out there
that handles fetching the return status and output params in an intuitive way?
A quick search of CPAN has revealed nothing.
I
[EMAIL PROTECTED] writes:
Where I work, we use a lot (thousands) of Sybase stored procedures and have only
recently adopted DBI and DBD::Sybase. Is there any DBIx-type module out there
that handles fetching the return status and output params in an intuitive way?
A quick search of CPAN
On Tue, Apr 02, 2002 at 12:51:49PM -0500, [EMAIL PROTECTED] wrote:
I have a proof-of-concept module that does this, tentatively called
DBIx::Sybase::StoredProc,
I'd suggest just Sybase::StoredProc
Tim.
Michael Peppler [EMAIL PROTECTED] wrote:
See the new 'exec proc syntax (with placeholders) that is supported
in 0.94. This does away with the need to declare OUTPUT parameters as
T-SQL variables.
Is this also in 0.93 as the manpage suggests? We have installed 0.93 and
upgrading is a
Hi,
I am trying to run an oracle stored procedure through the DBI the
procedure is stored in a package.
In the DBI faq it say that this is possible but I can not seem to get
it working.
This is the code I am using
#!/usr/local/bin/perl
use DBI;
use CGI;
print Content-Type: text/html\n\n;
I have some stored procedures and functions received from a third party that
have been wrapped. Is it possible to use DBD::Oracle to install these?
The
$rv = $sth-do($statement);
call is failing with:
Can't mix placeholder styles (:1/:foo) at DBD/Oracle.pm line 293.
Where
- Original Message -
From: Adam Gent [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, February 15, 2002 15:02
Subject: Oracle Stored Procedures and Packages
I am trying to run an oracle stored procedure through the DBI the
procedure is stored in a package.
In the DBI faq it say
1 - 100 of 139 matches
Mail list logo
