I could be wrong but I think there is/was some code in DBD::ODBC which treats
colons in SQL as parameter markers (and yours are not).
--
Martin J. Evans
Easysoft Ltd, UK
Development
On 06-Mar-2003 Dale Durham wrote:
> I have looked everywhere I can think of and tried tracing to isolate this
> this issue. I have not been able to figure it out. I am using DBI::ODBC to
> the Pervasive.SQL driver. Everything works great except for stored
> procedures with a colon in them. These same stored procedures work fine via
> ODBC, On example is:
>
> $dbh->prepare ("create procedure p1 ();
> begin
> declare :a int = 0;
> while (:a < 3)
> do
> begin
> insert into tDst select * from tSrc;
> end
> end while
> end;");
>
> Stored procs without a colon in them also work great. Any thoughts or ideas
> would be more than appreciated.
>
> Dale Durham
