• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Execute stored procedure

#10
[eluser]Unknown[/eluser]
[quote author="HugoA" date="1263953354"]doing this the problem is solved.
Code:
$db['default']['pconnect'] = FALSE;
by default it is set to TRUE.

So, you can use
Code:
$db['default']['dbdriver'] = "mysql";
and call your stored procedures like this
Code:
$query = $this->db->query('CALL getPersona()');

I have to do more tests, but the application is working now.[/quote]

THANK YOU, THANK YOU, THANK YOU!!!

I was finding virtually nothing concerning this problem until I saw your post. I just started using mySQL stored procedures with my CodeIgniter application... and shortly after got the deadly "Unable to select the specified database" message.

I opened my \application\config\database.php file and changed from:

$db['default']['pconnect'] = TRUE;

to

$db['default']['pconnect'] = FALSE;

and <knock on wood> haven't had the same problem since.


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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.