Hi Jon,
I have some problems with Oracle 10 and Doctrine 1.2 with symfony.
my connection on databases.yml
all:
web:
class: sfDoctrineDatabase
param:
dsn: 'oracle:dbname=//url:1521/sid'
username: web
password: xxxx
The user web has all privileges and the default tablespace is web but i have
this error on build (doctrine:build --all):
ORA-01031: insufficient privileges
I have generate sql to find my problem but i have a new problem because the sql
isn't correct
Example of my sql:
CREATE TABLE sf_guard_group (id NUMBER(10), name VARCHAR2(255) UNIQUE,
description VARCHAR2(1000), created_at DATE NOT NULL, updated_at DATE NOT NULL,
PRIMARY KEY(id))
/
CREATE TABLE sf_guard_group_permission (group_id NUMBER(10), permission_id
NUMBER(10), created_at DATE NOT NULL, updated_at DATE NOT NULL, PRIMARY
KEY(group_id, permission_id))
/
....
Why i have Slash between the line ?
Before execute on Oracle, i changed the / with ;
After that, i have this message (sorry this is in french)
La variable attachée (bind variable) "NEW" est NON DECLAREE
bloc anonyme terminé
Doctrine really allready work with Oracle ?
Need urgent help please because my new project use Oracle and my direction
doesn't change the DB.
Thank
Bertrand
--
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en.
