Re^2: Executing Oracle PL/SQL statements through the DBI

I think you're right. I can't replicate the problem I was having yesterday;. Whether I set define on or off in a SQLPlus session, my script using DBI/DBD::Oracle seems to happily insert the data without treating the embedded ampersand in any way special. This is very strange, since I'm pretty sure I was getting an error about that yesterday. (Well, I am becoming less sure every moment.)

I tried the BEGIN/END PL/SQL block because a simple

$sqlhandle->do("set define off");

wasn't working.

Thanks for helping me to understand the different rules that are in play in SQLPlus vs. through the DBI.

No good deed goes unpunished. -- (attributed to) Oscar Wilde

Comment on Re^2: Executing Oracle PL/SQL statements through the DBI Download Code