http://www.perlmonks.org?node_id=390104


in reply to Re: DBD::Sybase stored procedure question
in thread DBD::Sybase stored procedure question

Hi Michael and ccn,
Thanks to you both for your prompt responses. Michael, just so you know, I tried your solution, and while my script didn't die or anything, nothing got added to the database unfortunately. I had previously tried a solution very similar to this, but also without success.
ccn's code did work for me however, so I was wondering if the binding is necessary??
Thanks,
Martymart
  • Comment on Re^2: DBD::Sybase stored procedure question

Replies are listed 'Best First'.
Re^3: DBD::Sybase stored procedure question
by mpeppler (Vicar) on Sep 10, 2004 at 15:08 UTC
    No the binding isn't absolutely necessary. You can always use a "normal" SQL statement and pass all the values as literals.

    However, I wonder why nothing got added - maybe you should run a test with DBI->trace(3) and check that things actually run. There might be something that fails but that doesn't produce an error message for some reason.

    Michael