in reply to Re: Class::DBI::Oracle and views
in thread Class::DBI::Oracle and views

Well, I don't see anything wrong here. It's probably a bad idea to keep all of your packages in Modules.pl (as opposed to separate files) and there is no reason to use Class::DBI::Oracle if you're not using the set_up_table call, but neither of those should break it.

Can you access this view from DBI when you don't go through Class::DBI?

Replies are listed 'Best First'.
Re: Re: Re: Class::DBI::Oracle and views
by janjan (Beadle) on Sep 28, 2003 at 23:23 UTC
    Yeah, I know I should keep 'em in separate files -- I'm just putting all the packages in one place just for testing purposes. Also, I wanted to use Class::DBI::Oracle for the sequencing -- unless there's a better way? I'm still pretty new to the Class::DBI stuff.

    And yes, I can access the view just fine when I'm using plain ol' DBI. So frustrating! Do you think it might have something to do with the older version of Class::DBI that I'm using?
[reply]
      I could be wrong, but it doesn't look like Class::DBI::Oracle does anything special to make sequencing work unless you call set_up_table. Not sure about possible issues with your old version. Check the changelog and try asking on the Class::DBI mailing list.
[reply]
        Good lord, do I feel stupid -- after hours of poking, and even testing on a system that has a more recent Class::DBI -- I discovered that the problem was a typo in my package declaration.

        *sigh*

        Thanks for all your help, though. I do appreciate it.
[reply]

In Section Seekers of Perl Wisdom