That's an Oracle error and a quick search on Metalink indicates that
this tends to happen with tools like Pro*C and if DBD::Oracle uses the
OCI like Pro*C then this bug will apply also. It is reproducable in
8.1.x 9.0.x and 9.2.0.1 ... Apparently the solution is (guess what?)
upgrading to Oracle 10
Try replacing
$db = new Win32::ODBC("MP2", "LAURIEV", "MYPSWD");
...with
$db = new Win32::ODBC("DSN=MP2;UID=LAURIEV;PWD=MYPSWD;");
This is what I got from the Win32::ODBC documentation...
It also suggests that you check to make sure that your database handle
(in this case $db) is defined befo
http://www.google.com
Or news://comp.databases.oracle.server
Oracle Press publishes all you need to know about Oracle servers and
O'Reilly and Associates has a fair amount of Oracle books you can
purchase as well (at http://www.ora.com)
-Original Message-
From: Ian Harisay [mailto:[EMAIL
Make sure you have a public synonym for that function?
-Original Message-
From: Gauthier, Dave [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 27, 2003 10:59 AM
To: Steve Baldwin; [EMAIL PROTECTED]
Subject: RE: Using stored PL/SQL function
I think you've pinpointed it. I was NOT usi
Why not do something like this?
my $csr = $dbh->prepare(q{
BEGIN
my_package.my_procedure(:in_param);
:out_param := my_package.my_public_variable;
END;
});
$csr->bind_param(":in_param", $in_param);
$csr->bind_param_inout(":out_param", \$out_param, 80);
$csr-
The sender would like to recall the message, "database handle being DESTROY'd without
explicit disconnect msg".
I am writing a package for my own use at work.
In it there is a function that connects to an Oracle database, executes
a package procedure and then disconnects and returns a value.
When I call this from another script, I get
Issuing rollback() for database handle being DESTROY'd without explicit
Well, to paraphrase Johnny Cochrane...
"If the data fits, you must commit" :)
-Original Message-
From: Morrison, Trevor (Trevor) [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 25, 2003 9:10 AM
To: Ronald J Kimball
Cc: [EMAIL PROTECTED]
Subject: RE: DBD::Oracle problems
Sorry,
I shou
...and all the links point to http://www.cpan.org/index2.html which is the actual cpan
website...
Oh well... I guess geeks have to have their fun, too... :)
> -Original Message-
> From: William R. Mussatto [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, April 01, 2003 10:37 AM
> To: [EMAIL P
n user variables, I would think.
If you need information beyond this, I suggest you do some reading on the Windows NT
operating system.
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 26, 2003 1:26 PM
> To: Fernando Luna; [EMAIL
I found that this works for me when I pass the database link as a variable.
INSERT INTO [EMAIL PROTECTED]
SELECT * FROM foo
WHERE condition='bar';
>
> --- "Chen, Allen" <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > I've searched all over and can't seem to find an answer to this...
> > I have
>
I had this problem until I pointed ORACLE_HOME to a directory that contained all the
Pro*C executables. I think it's looking for your OCI installation...
> -Original Message-
> From: Tim Bunce [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, March 04, 2003 5:14 AM
> To: [EMAIL PROTECTED]
> Cc:
age-
> From: M Addlework [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 27, 2003 10:16 AM
> To: Fernando Luna
> Cc: [EMAIL PROTECTED]
> Subject: RE: Running SQL from files - was: Your DBI book
>
>
> Fernando,
>
> It's very naive to view this is just a task
The only problem I see with the approach of stripping out semi-colons before passing
DDL statements to Oracle is that CREATE PACKAGE statements have semi-colons all over
the place... in fact, you can't have a PACKAGE Specification and body without the
semi-colons which terminate each statement i
: Jeff Zucker [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 27, 2003 8:36 AM
> To: Fernando Luna
> Cc: [EMAIL PROTECTED]
> Subject: Re: Running SQL from files - was: Your DBI book
>
>
> Fernando Luna wrote:
>
> >>>What I'd like to do is read a file
>
>
> Fernando Luna wrote:
> > [...]
> > I am running perl version 5.005_03 built for AIX Unix.
>
> Get ready to upgrade.
>
So, is this version not stable enough for me to do what I want? Why should I worry
about upgrading right now?
> > I have Oracle
ars to choke on
some keywords that Oracle has no trouble with, but I suspect has to
do with the fact that they are not necessarily ANSI-SQL compliant.
Is this something that might be covered in this book or can you tell me if this just
cannot be done with these modules?
Thanks
Fernando Luna - Seattle, WA
There is the need at my organization to process DDL statements
contained in a group of SQL files.
I have been able to greatly simplify a number of tasks using perl and I was hoping to
likewise be able to use perl and the DBD::Oracle modules to get this accomplished.
I would like to know what th
18 matches
Mail list logo