Prepare Statement Limitiations - URGENT ANSWER NEEDED

[AFBIII]

Is anyone aware of if the Prepare statement is limitted to the size of buffer you pass into it in regards to a dynamic SQL?

we recently had a dynamic SQL hit 80,000 characters in length and now it appears that the prepare statement is truncating the buffer that we are passing in and not all of the statement is getting prepared causing errors to occur with the SQL statement.

[debasisdas]

Before executeion try storing the SQL statment in a LONG variable in place of usual VARCHAR2.