[thesite] t.e.o. updates

[.jeff]

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/