372:
373: function check_if_schema_exists (schema_name in varchar2)
374: return boolean is
375: cursor c1 is 376: select name from sys.user$ 377: where name = upper(check_if_schema_exists.schema_name);
378: begin
379: for c1rec in c1 loop
380: -- at least one row was returned so the user exists.