[thesite] t.e.o. updates
.jeff
jeff at members.evolt.org
Sat Nov 17 14:25:27 CST 2001
rudy,
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: rudy
>
> you're talking about
> http://www.orafaq.com/msgboard/tools/messages/2146.htm,
> right?
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
yeah. tried that and i'm getting an oracle error:
Oracle Error Code = 4031
ORA-04031: unable to allocate 4096 bytes of shared memory ("shared
pool","STANDARD","PL/SQL MPCODE","BAMIMA: Bam Buffer") ORA-06508: PL/SQL:
could not find program unit being called ORA-06512: at "EVOLTTEST.RAND",
line 7 ORA-06512: at line 1
SQL = "SELECT content.contentid , content.keyphrase , content.contentname ,
content.synopsis , content.datemod , content.replies , content.rating ,
content.ratings , users.userid , users.who , categorys.category ,
categorys.categoryid , rand.random AS rank FROM content , users , categorys
WHERE categorys.categoryid = content.categoryid AND content.userid =
users.userid AND content.signoff = 1 AND content.categoryid NOT IN (1, 23,
26, 9741) AND content.datemod < '17-Nov-00' ORDER BY rank"
Data Source = "EVOLTTEST"
dean, you got any ideas about this?
thanks,
.jeff
http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/
More information about the thesite
mailing list