ORA - 6502

I am creating a query dynamically using lexical references.

Select type1
from tab1
where &whereclause

I build the &whereclause in a procedure which is called from a formula column.This value is then passed thru the placeholder column to my query. But when my &whereclause size is more than 100 bytes , I get ORA - 6502 error.

Is there any other way of passing this lexical value ??

Regards
Siva

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Apr 01 1999 - 22:58:21 CEST