[Dbix-class] Error when generating the Oracle schema

Octavian Râşniţă octavian at fcc.ro
Sat Aug 15 08:21:22 GMT 2009


Hi,

I have tried to generate the DBIC result classes using the Catalyst helper:

perl script/tb_create.pl model DAT DBIC::Schema TB::DATSchema create=static
'dbi:Oracle:host=10.30.12.20;sid=datar' username password

But it gave an error and it didn't create any file:

DBIx::Class::Schema::Loader::make_schema_at(): No such column
sys_nc0000500006$ on table portofoliu_cache at
/usr/lib/perl5/site_perl/5.8.8/Catalyst/Helper/Model/DBIC/Schema.pm line 173

I have seen that this table doesn't have a column name sys_nc0000500006$ but
I don't know why DBIC schema wants it.

Is there anything I can do to generate the table classes in this case?

(I have also tried to use a different username that has permissions to view 
fewer tables, but the helper created only the DATSchema.pm class file and no 
result class files.)

Thank you.

Octavian




More information about the DBIx-Class mailing list