Dear all I have 2 schemas , schema1 and schema 2.
1. GRANT USAGE ON SCHEMA schema1 TO schema2; I am trying to create a function in shema2, In that function I need to access some tables from schema1. p I am getting the following error when I compile the function Search path set to schema2,schema1,public Can you please help? Appreciate your time Regards