Hi folks.
As part of our implementation of Moodle, I've been looking at getting the authentication and enrolment plugins set up so that all our students and staff can log in using their network credentials and be automatically enrolled in the courses our MIS system says they're on. Getting authentication working with LDAP was fairly straightforward, but I'm having some diffculty with the enrolment plugin side of it.
So far I have managed to get Moodle talking to Oracle (the database behind our student records system) using the "oci8po" setting as recommended on this forum, but I can only get it to do the enrolments when I give it a table as the db_table parameter - it won't return anything when I give it a view. I find this a bit odd as the majority of drivers that I've used before to talk to Oracle from other databases seem to treat tables and views more or less the same. I would really like to use a view if possible so that the enrolment data is dynamic rather than having to script periodical updates to a static table.
Can anyone suggest why it might be that a table is acceptable as a source to Moodle when a view is not? Has anyone else successfully used an Oracle view as a source for an enrolment plugin before?
Thanks!