Hi Martin,
this is not Perl stuff but Oracle PL/SQL.
Just take your 'get' procedure:
PROCEDURE get(
pdt OUT mytable.created%TYPE,
pcur OUT SYS_REFCURSOR) AS
BEGIN
pdt := utc_timestamp();
OPEN pcur FOR
SELECT DISTINCT(id) F
- Forwarded message from John Rowan <[EMAIL PROTECTED]> -
Date: Wed, 22 Oct 2008 09:50:23 -0400
From: John Rowan <[EMAIL PROTECTED]>
Subject: DBI.pm
Good day Tim. I need to steal some of your time.
I run a content management system from PlainBlack Software called WebGUI.
This s
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: suggestions sought on returning rows f
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:
creat
Steve Baldwin wrote:
Martin,
Personally I would use a global temporary table in this scenario.
However if that is considered offensive or morally dubious, you could do
something like :
package pkg1
type t1 is table of mytable%rowtype index by binary_integer
g_tt1
g_ipls_integer
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 a timestamp:
>
> create mytabl
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
Martin,
Personally I would use a global temporary table in this scenario.
However if that is considered offensive or morally dubious, you could do
something like :
package pkg1
type t1 is table of mytable%rowtype index by binary_integer
g_tt1
g_ipls_integer
function f1 return pls
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
11 matches
Mail list logo
