, 10/23/08, Martin Evans <[EMAIL PROTECTED]> wrote:
From: Martin Evans <[EMAIL PROTECTED]>
Subject: Re: suggestions sought on returning rows from oracle proc and deleting
them in same proc
To: "dbi-users"
Date: Thursday, October 23, 2008, 8:40 AM
John,
John Scoles
;
> Subject: Re: suggestions sought on returning rows from oracle proc and
> deleting them in same proc
> To: "dbi-users"
> Date: Thursday, October 23, 2008, 8:40 AM
> John,
>
> John Scoles wrote:
> >
> >
> > Martin Evans wrote:
> >> C
John,
John Scoles wrote:
Martin Evans wrote:
Christian Merz wrote:
Hi Martin,
this is not Perl stuff but Oracle PL/SQL.
I disagree. I'm using DBD::Oracle and I need the values selected in
the procedure returned to perl. The reason it is particularly
applicable to DBD::Oracle is that it
Martin Evans wrote:
Christian Merz wrote:
Hi Martin,
this is not Perl stuff but Oracle PL/SQL.
I disagree. I'm using DBD::Oracle and I need the values selected in
the procedure returned to perl. The reason it is particularly
applicable to DBD::Oracle is that it would be possible to solve
rom: Martin Evans [mailto:[EMAIL PROTECTED]
Sent: 22 October 2008 17:19
To: Stewart Anderson
Cc: dbi-users
Subject: Re: suggestions sought on returning rows from oracle proc and
deleting them in same proc
Stewart Anderson wrote:
Subject: suggestions sought on returning rows from oracle proc an
an only treat the latter ones in a LOOP.
cu, Christian
From: Martin Evans [mailto:[EMAIL PROTECTED]
Sent: 22 October 2008 17:19
To: Stewart Anderson
Cc: dbi-users
Subject: Re: suggestions sought on returning rows from oracle proc and
deleting them in same proc
Stewart Anderson wrote:
Subject: sug
On Wed, Oct 22, 2008 at 9:12 AM, Martin Evans <[EMAIL PROTECTED]> wrote:
> John Scoles wrote:
>>
>> Well what you might want to do is convert the out data like this
>>
>> SELECT SYSTIMESTAMP,to_char(SYSTIMESTAMP,'mm--dd:hh:s') FROM dual
I usually just add this after every connect():
$d
> From: Martin Evans [mailto:[EMAIL PROTECTED]
> Sent: 22 October 2008 17:19
> To: Stewart Anderson
> Cc: dbi-users
> Subject: Re: suggestions sought on returning rows from oracle proc and
> deleting them in same proc
>
> Stewart Anderson wrote:
> >> Subject: sug
Stewart Anderson wrote:
Subject: suggestions sought on returning rows from oracle proc and
deleting them in same proc
Hi,
I am hoping someone might have had to do something like this and have
a
good solution. I am using DBD::Oracle. I have a table with a simple
integer and a timestamp
John Scoles wrote:
Well what you might want to do is convert the out data like this
SELECT SYSTIMESTAMP,to_char(SYSTIMESTAMP,'mm--dd:hh:s') FROM dual
adding to the end of the to_char down to the resolution you need.
DBD::Oracle should return this correctly.
cheers
John Scoles
> Subject: suggestions sought on returning rows from oracle proc and
> deleting them in same proc
>
> Hi,
>
> I am hoping someone might have had to do something like this and have
a
> good solution. I am using DBD::Oracle. I have a table with a simple
> integer and
Well what you might want to do is convert the out data like this
SELECT SYSTIMESTAMP,to_char(SYSTIMESTAMP,'mm--dd:hh:s') FROM dual
adding to the end of the to_char down to the resolution you need.
DBD::Oracle should return this correctly.
cheers
John Scoles
Martin Evans wrote
Hi,
I am hoping someone might have had to do something like this and have a
good solution. I am using DBD::Oracle. I have a table with a simple
integer and a timestamp:
create mytable (id int, created timestamp);
The integer value may appear more than once and the timestamp is the
timestamp
13 matches
Mail list logo
