#3163: DboOracle should support stored procedures
-----------------------------------------------------------------+----------
Reporter: daniel.asanome |
Owner: phishy
Type: Enhancement |
Status: new
Priority: Medium |
Milestone: 1.2.x.x
Component: Oracle |
Version: RC1
Severity: Normal |
Resolution:
Keywords: oracle stored procedure sp daniel.asanome phishy |
Php_version: PHP 5
Cake_version: |
-----------------------------------------------------------------+----------
Comment (by daniel.asanome):
Hi Emnu.[[BR]]
[[BR]]
I just saw your post.[[BR]]
Its a good way to use it. To tell the truth its easier then my
approach.[[BR]]
But i also have to say that was just a fast and not pratic solution for a
problem.[[BR]]
[[BR]]
But I have some good news. I just made a new driver. That's return a the
same way that a find() returns.[[BR]]
When you see it you can think that isnt easier than the first. But its
alot easier to use when you need to develop a medium to large application
(that is my case). Because you dont need to always make a entire
call.[[BR]]
Here is an example of a call in a controller.[[BR]]
[[BR]]
{{{
//execSp('Owner.Pack_name.sp', 'in_parameters');
$spReturn = $this->ModelName->execSp('Owner.PACK_NAME.stp_S_findname',
array ('Daniel', 'Asanome'));
}}}
[[BR]]
Its will return.[[BR]]
[[BR]]
{{{
array(1) {
["rs_cursor"]=>
array(1) {
[0]=>
array(5) {
["id"]=>
string(1) "1"
["firstname"]=>
string(6) "Daniel"
["middlename"]=>
string(5) "Rocha"
["lastname"]=>
string(7) "Asanome"
["email"]=>
string(27) "[EMAIL PROTECTED]"
}
}
}
}}}
[[BR]]
And the better part of it that I think its you dont need to modify the
actual Oracle's driver, you just need to add my driver to the directory
'cake/cake/libs/model/datasources/dbo' and make another directory to store
yours packages.[[BR]]
[[BR]]
Well i think that its all.[[BR]]
Any problems you can see the code comments or just reply.[[BR]]
[[BR]]
Thanks.
--
Ticket URL: <https://trac.cakephp.org/ticket/3163#comment:7>
CakePHP : The Rapid Development Framework for PHP <https://trac.cakephp.org/>
Cake is a rapid development framework for PHP which uses commonly known design
patterns like ActiveRecord, Association Data Mapping, Front Controller and MVC.
Our primary goal is to provide a structured framework that enables PHP users at
all levels to rapidly develop robust web applications, without any loss to
flexibility.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"tickets cakephp" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/tickets-cakephp?hl=en
-~----------~----~----~----~------~----~------~--~---
