[web2py] Re: Oracle DB - Select into an existing table DAL problem.

2011-03-18 Thread Pivert
Thanks, This is unfortunately quite heavy to redefine the tables with define_table, but it works. I did not yet tried for the tables without primary key. Regards, On Mar 9, 6:42 am, cjrh wrote: > On Mar 8, 9:26 pm, Pivert wrote: > > > - My first problem was a major typo in the documentation. F

[web2py] Re: Oracle DB - Select into an existing table DAL problem.

2011-03-08 Thread cjrh
On Mar 8, 9:26 pm, Pivert wrote: > - My first problem was a major typo in the documentation. For oracle > connector, the username and password are not separated by : but by /, > to the oracle connection string is : > oracle://username/password@DBNameInTnsnamesFile' Fixed, thank you.

[web2py] Re: Oracle DB - Select into an existing table DAL problem.

2011-03-08 Thread pbreit
Most likely you are going to need to somehow retrieve the schema of the Oracle db and then hand-code your models to match. There are scripts that can help for MySQL and Postgres but I don't think that's going to work for you: http://code.google.com/p/web2py/source/browse/#hg%2Fscripts You also