[Oracle][ODBC][ORA][PHP] - Probleem connecting to the database

[bouvrie]

Hello everyone!

There's a problem I cannot fix. I've been trying to find a solution on various websites, but nothing helpfull turned up... The problem is this:

SQL error: [Oracle][ODBC][Ora]ORA-00604: error occurred at recursive SQL level 2 
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","TRIGGER$","sga heap","state objects") 
ORA-00604: error occurred at recursive SQL level 1 
ORA-04031: unable to allocate 4200 bytes of shared memory ("shared pool","unknown object","sga heap","state objects"),
SQL state S1000 in SQLConnect in D:\InetPub\wwwroot\dbconnect.php on line 2

I was wondering if you guys know something about this and maybe even had the experience or luck to correct this error. Any help would be greatly appreciated!

Thanks in advance!

[edit]typo[/edit]

[bastien]

the shared pool in the oracle server does not have enough free memory to store the sql and compare it to the other sql statements that have run....

try resizing the sga or adding more granules to the sp...

hth