in reply to Executing Oracle PL/SQL statements through the DBI

Have you tried using placeholders for your data?

---
It's all fine and dandy until someone has to look at the code.
  • Comment on Re: Executing Oracle PL/SQL statements through the DBI

Replies are listed 'Best First'.
Re^2: Executing Oracle PL/SQL statements through the DBI
by ptum (Priest) on Mar 14, 2006 at 15:48 UTC

    Hmmmm. That seems like a good idea. I don't usually use placeholders and the prepare/execute approach unless I am looking for performance gains on a repeated operation, but in this case it might prevent Oracle from treating the ampersand as a variable reference since it would be already inside a bind variable. I'll try it ... and post an update. It will take me a little while to set it up ... the actual insert is in a SUPER class, but I build the statement lower in the inheritance chain. Thanks.


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