Yes, it can return a cursor. My module does not handle this case (yet...). To use a cursor, you have to explicitly declare this type to DBI, and then you can fetch from it.

So for now: yes, Oracle can, but Oracle::Procedures cannot.

Your check will fail to detect an error if I call it like-a-so: sysdate(\1).

True.