Recent content by Ferk0

Hi I have a problem with the TOracleQuery component, when I set a very long SQL statement (Like the one attached to this mail) the component works very well only at the beginning, but after some time it failed, the SQL statement is 4600 characters long and when I was debugging it, it says that...

I've tried to grant roles using OracleQuery (The roles sometimes are made of another roles), first of all I generate the sql at runtime. QRY_GrantRoles.SQL.clear; QRY_GrantRoles.SQL.Add('GRANT '+VLS_Sql+ ' TO '+ VSS_CurrentUser); It works well, but when the number of users grows, the app stops...