Re^2: Passing a perl variable in SQL AND statement

Thank you for your reply. I tried that. I still get SQL error.

DBD::Oracle::db prepare failed: ORA-00911: invalid character (DBD ERRO
+R: error possibly near <*> indicator at char 84 in 'Select *
From SMSVA_SUPR.schedule_table
where process_name = 'Seed'
and Sunday = 'Y'<*>;
') [for Statement "Select *
From SMSVA_SUPR.schedule_table
where process_name = 'Seed'
and Sunday = 'Y';
"] at seed_driver.pl line 93.
DBD::Oracle::db prepare failed: ORA-00911: invalid character (DBD ERRO
+R: error possibly near <*> indicator at char 84 in 'Select *
From SMSVA_SUPR.schedule_table
where process_name = 'Seed'
and Sunday = 'Y'<*>;
') [for Statement "Select *
From SMSVA_SUPR.schedule_table
where process_name = 'Seed'
and Sunday = 'Y';
"] at seed_driver.pl line 93.
[download]

Comment on Re^2: Passing a perl variable in SQL AND statement Download Code

Replies are listed 'Best First'.
Re^3: Passing a perl variable in SQL AND statement by dasgar (Priest) on Nov 20, 2013 at 21:06 UTC
Based on what the error message is complaining about, I'd recommend that you try to remove the semi-colon at the end of the SQL statement. Also, I don't know where your variable will be getting it's values from, but you might want to check out Little Bobby Tables for info about preventing SQL injection issues.	[reply]
Re^4: Passing a perl variable in SQL AND statement by vihar (Acolyte) on Nov 20, 2013 at 21:18 UTC
That was a silly mistake on my end. I took out ; and it worked. Thanks for your help!	[reply]