Hi cliff,
I plugged that statement into my
code and it's still having a problem.
Could you take a look at my code to
see what the problem could be:
$dbh = DBI->connect("dbi:Oracle:",'username','password');
my $sth = $dbh->prepare(qq{select sysdate into :mydate from dual});
if ( $sth ) {
$sth->execute;
}
$dbh->disconnect;
regards,
John
-----Original Message-----
From: Cliff [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 20, 2003 4:30 PM
To: John Deretich
Cc: Perl-Win32-Admin-Request \(E-mail\)
Subject: Re: sql statements
yes and yes. you are pulling the current oracle system date from the dummy
table
dual, and loading it into a user variable. in essence, you are getting the
localtime according to the oracle system you query.
-~.-~.-~.-~.-~.-~.-~.-~.-~.-~
-~
-~ Cliff Frensley
-~ [EMAIL PROTECTED]
-~ Seattle, WA
-~
-~
-.
On Thu, 20 Feb 2003, John Deretich wrote:
> Hi
>
> does anyone understand
> this sql statement, select sysdate into :mydate from dual,
> using the dbi module? And is the :mydate a variable where the
> sysdate gets loaded into?
>
> regards,
>
> John
> _______________________________________________
> Perl-Win32-Admin mailing list
> [EMAIL PROTECTED]
> To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
>
_______________________________________________
Perl-Win32-Admin mailing list
[EMAIL PROTECTED]
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
