Re: Strange error when doing insert into DB

On Mon, 2006-02-20 at 21:08 +0530, Hemlata Lalwani wrote:
> Hi,
> Please give a look at below source code if this can help you:

This is Oracle.pm code, which is not your code that is in error.
I'm sorry if you cannot send your actual code, I can't show where
to fix your code.

>
> package DBD::Oracle::db; # ====== DATABASE ======
> use strict;
>
> sub prepare {
> my($dbh, $statement, @attribs)= @_;
>
> # create a 'blank' sth
>
> my $sth = DBI::_new_sth($dbh, {
> 'Statement' => $statement,
> });
>
> # Call Oracle OCI parse func in Oracle.xs file.
> # and populate internal handle data.
>
> DBD::Oracle::st::_prepare($sth, $statement, @attribs)
> or return undef;
>
> $sth;
>



> Waiting for your help..Also wud like to know how i can add myself in this

Go to the link below,

http://lists.cpan.org/showlist.cgi?name=dbi-users



> list ..
>
> Regards,
> -Hemlata Lalwani
>
> ----- Original Message -----
> From: "Scott T. Hildreth"
> To: "Hemlata Lalwani"
> Cc:
> Sent: Monday, February 20, 2006 8:59 PM
> Subject: RE: Strange error when doing insert into DB
>
>
> > On Mon, 2006-02-20 at 20:05 +0530, Hemlata Lalwani wrote:
> > > Hi,
> > > Iam also having the same problem..the piece of code is as
> > > below:
> >
> > I'm sorry I don't know what this is referring to?
> > >
> > >
> > > DBD::Oracle::st::_prepare($sth, $statement, @attribs)
> > > or return undef;
> >
> > Are you coding it this way or is this coming from a trace?
> >
> > Can you post some code?
> >
> > >
> > > would really appreciate if you help me..
> >
> > I would like to help, but I need more info or code to look at.
> > Also I am cc the dbi-users list, this is where these questions
> > should be asked.
> >
> > > Also The error i got in my qmail logs is
> > >
> > > Can't mix placeholder styles (:foo/:1) at
> >
> > Well you can't, I would need to see the $statemnet in order to help.
> >
> > > /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/O racle.pm
> > > line
> > > 293.
> > > Which i got when i insert the mail into databse..this mail actually
> > > bouced back...
> > >
> > > Regards,
> > > -Hemlata Lalwani
> > > Hemlata Lalwani | Linux Administrator ( Systems ) I Webdunia.Com
> > > (India) Pvt Ltd | 582 MG Road Indore MP | Work +91-731-398-3426 |
> > > Mobile +91-930-079-7948 I Fax +91-731-243-6615 | www.webdunia.net
> > >
> > >
> > --
> > Scott T. Hildreth
> >
>
--
Scott T. Hildreth

Re: Strange error when doing insert into DB

Hi,
Which code do you want?Like the error says abt this path..

/usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/O racle.pm
So shall i give you the code of this?If not which code we want
...please tell me..

Regards,
-Hemlata Lalwani

----- Original Message -----
From: "Scott T. Hildreth"
To: "Hemlata Lalwani"
Cc:
Sent: Monday, February 20, 2006 9:35 PM
Subject: Re: Strange error when doing insert into DB


> On Mon, 2006-02-20 at 21:08 +0530, Hemlata Lalwani wrote:
> > Hi,
> > Please give a look at below source code if this can help you:
>
> This is Oracle.pm code, which is not your code that is in error.
> I'm sorry if you cannot send your actual code, I can't show where
> to fix your code.
>
> >
> > package DBD::Oracle::db; # ====== DATABASE ======
> > use strict;
> >
> > sub prepare {
> > my($dbh, $statement, @attribs)= @_;
> >
> > # create a 'blank' sth
> >
> > my $sth = DBI::_new_sth($dbh, {
> > 'Statement' => $statement,
> > });
> >
> > # Call Oracle OCI parse func in Oracle.xs file.
> > # and populate internal handle data.
> >
> > DBD::Oracle::st::_prepare($sth, $statement, @attribs)
> > or return undef;
> >
> > $sth;
> >
>
>
>
> > Waiting for your help..Also wud like to know how i can add myself in
this
>
> Go to the link below,
>
> http://lists.cpan.org/showlist.cgi?name=dbi-users
>
>
>
> > list ..
> >
> > Regards,
> > -Hemlata Lalwani
> >
> > ----- Original Message -----
> > From: "Scott T. Hildreth"
> > To: "Hemlata Lalwani"
> > Cc:
> > Sent: Monday, February 20, 2006 8:59 PM
> > Subject: RE: Strange error when doing insert into DB
> >
> >
> > > On Mon, 2006-02-20 at 20:05 +0530, Hemlata Lalwani wrote:
> > > > Hi,
> > > > Iam also having the same problem..the piece of code is as
> > > > below:
> > >
> > > I'm sorry I don't know what this is referring to?
> > > >
> > > >
> > > > DBD::Oracle::st::_prepare($sth, $statement, @attribs)
> > > > or return undef;
> > >
> > > Are you coding it this way or is this coming from a trace?
> > >
> > > Can you post some code?
> > >
> > > >
> > > > would really appreciate if you help me..
> > >
> > > I would like to help, but I need more info or code to look at.
> > > Also I am cc the dbi-users list, this is where these questions
> > > should be asked.
> > >
> > > > Also The error i got in my qmail logs is
> > > >
> > > > Can't mix placeholder styles (:foo/:1) at
> > >
> > > Well you can't, I would need to see the $statemnet in order to help.
> > >
> > > > /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/O racle.pm
> > > > line
> > > > 293.
> > > > Which i got when i insert the mail into databse..this mail actually
> > > > bouced back...
> > > >
> > > > Regards,
> > > > -Hemlata Lalwani
> > > > Hemlata Lalwani | Linux Administrator ( Systems ) I Webdunia.Com
> > > > (India) Pvt Ltd | 582 MG Road Indore MP | Work +91-731-398-3426 |
> > > > Mobile +91-930-079-7948 I Fax +91-731-243-6615 | www.webdunia.net
> > > >
> > > >
> > > --
> > > Scott T. Hildreth
> > >
> >
> --
> Scott T. Hildreth
>

Re: Strange error when doing insert into DB

On Tue, Feb 21, 2006 at 10:17:44AM +0530, Hemlata Lalwani wrote:
> Hi,
> Which code do you want?Like the error says abt this path..
>
> /usr/lib/perl5/site_perl/5.8.0/i386-linux-thread-multi/DBD/O racle.pm
> So shall i give you the code of this?If not which code we want
> ..please tell me..

> > > > > Can't mix placeholder styles (:foo/:1) at
> > > >
> > > > Well you can't, I would need to see the $statemnet in order to help.

It's the SQL statement you are passing to prepare() that has the problem,
not a perl statement. Please post the SQL statement.

Tim.