Using DBIx::Class::Schema::Loader with Oracle

cLive ;-) has asked for the wisdom of the Perl Monks concerning the following question:

I've tried to create a DBIx Schema for an Oracle DB, but all I'm getting is the basic schema class. It's been a while since I've touched Oracle (and DBIx::Class from first principles), so I'm wondering if I'm missing something obvious.

perl -MDBIx::Class::Schema::Loader=make_schema_at,dump_to_dir:./lib -e 'make_schema_at("My::Schema", { debug => 1 }, [ ... credentials ... ]

On running, I just get the one module:

./lib/My/Schema.pm

I was under the impression that I would get a full schema dump of all the tables in the DB.

Using the same credentials, I can get a $dbh and run the query

SELECT table_name FROM all_tables ORDER BY table_name

to get a list of all the tables, so why can't I get the Schema definitions for them? Would it be a user permission? If so, how would I check what perms my user has? At the moment, I'm going in blind and not sure what questions I need to be asking, so any insights appreciated. If I need to get a different user for this I guess I'll put in the request, but I was hoping to be able to work it out with what I have.

Running SELECT * FROM USER_TAB_PRIVS I see a bunch of select/update/execute perms.

Running SELECT * FROM USER_SYS_PRIVS gives me nothing.

Running SELECT * FROM USER_ROLE_PRIVS gives me a bunch of perms (not sure what they all are just yet, only that they exist).

Comment on Using DBIx::Class::Schema::Loader with Oracle Download Code

Replies are listed 'Best First'.

Re: Using DBIx::Class::Schema::Loader with Oracle
by silent11 (Vicar) on Jun 15, 2022 at 04:39 UTC

table

DBIC::Schema::Loader

everything

update: have you tried passing dump_directory?

make_schema_at('Company::Project', 
 { debug => 1, dump_directory => './lib'}, [credentials...]
);
[download]

[reply]
[d/l]
[select]


Perl-Sensitive Sunglasses
	PerlMonks