[eluser]Unknown[/eluser]
I just started to play around with CodeIgniter using an OracleDB as backend. I'm getting the feeling that things don't really work as smooth as I hoped and would love to hear what you think.
For example, If I try to trigger a stored procedure that simply takes a number as input and returns it, I get different values back each time I run it, but never the one I put in.
Code:
$params = array(
array('name'=>':P_NUM', 'value'=>$dat, 'type'=>SQLT_INT, 'length'=>-1),
array('name'=>':P_OUT', 'value'=>&$res2, 'type'=>OCI_B_INT, 'length'=>-1)
); );
If I change that to take characters (SQLT_CHR) as in parameter and return '1' instead (and of course, modify the plsql function) it will give me random errors. In fact I never managed to handle Strings, CHARS or VARCHARS in any stored procedure using CI, maybe I do something wrong.
However, my feeling is that I would need to do a lot of rewriting if I decide to go with CI and Oracle, am I wrong?
Regards
