212:
213: function check_if_schema_exists (schema_name in varchar2)
214: return boolean is
215: cursor c1 is 216: select name from sys.user$ 217: where name = upper(check_if_schema_exists.schema_name);
218: begin
219: for c1rec in c1 loop
220: -- at least one row was returned so the user exists.