In a Phalcon project, I have multiple database in Oracle and mySQL with number of tables and views. Created models for corresponding tables and views. But unable to access views. I initialize in model below:
public function initialize()
{
$this->setConnectionService('dbBznes');
$this->setSchema('POLICY');
$this->setSource("BUSINESS_ALL");
// view name
}
Return error message :
Table 'POLICY'.'BUSINESS_ALL' doesn't exist in database
if I use $this->setSource("table1"); is working fine but $this->setSource("view1"); showing error.