Welcome Guest, Not a member yet? Register   Sign In
Execute stored procedure
#1

[eluser]HugoA[/eluser]
Hi!
I'm executing a store procedure like this

Code:
$query = $this->db->query('CALL getPersona()');
but it just work one time (the first one), then, I have to restart the apache server because if I don't do it I get this error

Quote:A Database Error Occurred

Unable to select the specified database: todo

If I query mi database like this
Code:
$this->db->where('idpersona','1');
$query = $this->db->get('persona');

There's no problem at all...

What I'm doing wrong when I execute the stored procedure?

Thanks!


Messages In This Thread
Execute stored procedure - by El Forum - 01-18-2010, 09:43 AM
Execute stored procedure - by El Forum - 01-18-2010, 09:51 AM
Execute stored procedure - by El Forum - 01-18-2010, 10:04 AM
Execute stored procedure - by El Forum - 01-18-2010, 10:28 AM
Execute stored procedure - by El Forum - 01-18-2010, 04:54 PM
Execute stored procedure - by El Forum - 01-19-2010, 01:41 AM
Execute stored procedure - by El Forum - 01-19-2010, 01:51 PM
Execute stored procedure - by El Forum - 01-19-2010, 02:09 PM
Execute stored procedure - by El Forum - 03-15-2010, 09:41 PM
Execute stored procedure - by El Forum - 08-05-2010, 01:14 PM



Theme © iAndrew 2016 - Forum software by © MyBB