--
-- xooauth_credentials_f/1
--
create or replace function xooauth_credentials_f(
  p_new xooauth_credentialsi
) returns void as $$

             declare
               v_revision_id integer;
             begin

               select content_revision__new(
                                     p_new.title,
                                     p_new.description,
                                     p_new.publish_date,
                                     p_new.mime_type,
                                     p_new.nls_language,
                                     case when p_new.text is null 
                                              then p_new.data 
                                              else p_new.text
                                           end,
                                     content_symlink__resolve(p_new.item_id),
                                     p_new.revision_id,
                                     now(),
                                     p_new.creation_user, 
                                     p_new.creation_ip,
                                     null,                    -- content_length
                                     p_new.object_package_id
                ) into v_revision_id;
                insert into xooauth_credentials ( credentials_id, identifier, secret, client_metadata_id, server_metadata_id ) values (v_revision_id, p_new.identifier, p_new.secret, p_new.client_metadata_id, p_new.server_metadata_id);
    
   return;
   end;$$ language plpgsql;