Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:
Hi Monks
i am getting the following error
Placeholder :0 invalid, placeholders must be >= 1 at C:/Perl/lib/DBD/Oracle.pm l ine 273, <$data_fh> line 7.
While executing the following query
my $SQL ="Select tran_seq_nbr, sale_amount From Header Where org_number = 8 And store_number = 3 And tran_number = 2127 And terminal_number = 8 And tran_Date = to_date('$date','YYYY-MM-DD HH24:MI:SS')";
for date i have value like this:2007-08-10 00:00:00
how can i overcome this error
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Date Problem
by marto (Cardinal) on Apr 26, 2010 at 09:15 UTC | |
by Anonymous Monk on Apr 26, 2010 at 09:55 UTC | |
by marto (Cardinal) on Apr 26, 2010 at 10:59 UTC | |
by nagalenoj (Friar) on Apr 26, 2010 at 10:36 UTC | |
Re: Date Problem
by moritz (Cardinal) on Apr 26, 2010 at 09:26 UTC | |
by Anonymous Monk on Apr 26, 2010 at 09:35 UTC | |
by moritz (Cardinal) on Apr 26, 2010 at 10:37 UTC | |
by nagalenoj (Friar) on Apr 26, 2010 at 12:02 UTC |
Back to
Seekers of Perl Wisdom