I do not know actually as I am not the Oracle expert (or even regular user).
Will find out tomorrow.
Suppose - I can't - can you give any clue how to make an alias in web2py?
The ideal would be something like this:
db.define_table('inet', internal_name='rad....@inet',
Field('ip','string',length=16),
migrate=False
)
On Tue, Dec 22, 2009 at 5:47 PM, mdipierro <mdipie...@cs.depaul.edu> wrote:
> No. "." and "@" are not allowed in table names. Can you alias in
> Orcale?
>
> On Dec 22, 12:15 am, Alexey Nezhdanov <snak...@gmail.com> wrote:
> > Hello.
> > I've googled this group for my problem, but didn't find the answer.
> > It seems that problem was mentioned once [1] [2], but I do not know if
> any
> > solution was done.
> >
> > I need to connect to existing database so things like 'schemas are not
> > portable' are not really acceptable - I should be able to connect,
> period.
> > What is worse - there are actually two servers - DB2 and Oracle. I do not
> > have direct access to DB2 database and have to connect through Oracle.
> > So the sql query looks like this:
> >
> > SELECT ip FROM rad....@inet
> >
> > so here is scheme RAD, table NAS at the 'INET' DB2 database.
> >
> > web2py refuses me to do this:
> >
> > db.define_table('rad....@inet',
> > Field('ip','string',length=16),
> > migrate=False
> > )
> >
> > So what should I do? Is there any way out?
> > Thanks
> >
> > [1]
> http://groups.google.com/group/web2py/search?group=web2py&q=oracle+ta...
> > [2]
> http://groups.google.com/group/web2py/browse_thread/thread/3c27af0533...
> >
> > --
> > Regards
> > Alexey Nezhdanov
>
> --
> Regards
>
Alexey
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
