On Mon, 13 Nov 2006 18:03:42 GMT, Ralph wrote:
>
> Hi
>
> I'm trying to call SP from PHP but I can do that only when i use
> mysql_connect like this:
>
> mysql_connect($dbsettings['dbhost'], $dbsettings['dbuser'],
> $dbsettings['dbpass'], false, 65536);
>
> When I try persistent connection:
>
> mysql_pconnect($dbsettings['dbhost'], $dbsettings['dbuser'],
> $dbsettings['dbpass'], 65536);
>
> I'm getting error:
>
> PROCEDURE findPath can't return a result set in the given
> context[code]=> 1312
>
> How can I use persistent connection with this flag?
>
> I use
> PHP 5.1.6
> MySQL 5.0.24a-log

What problem are you trying to fix? Does your call return an error when
you use a non-persistant connection? If so, what does it say? (I've used
stored procedures from PHP on both MqSQL and DB2, and it's been quite
succesful for my purposes.)

--
37. If my trusted lieutenant tells me my Legions of Terror are losing a
battle, I will believe him. After all, he's my trusted lieutenant.
--Peter Anspach's list of things to do as an Evil Overlord