category_synonym::delete (public)

 category_synonym::delete synonym_id

Defined in packages/categories/tcl/category-synonyms-procs.tcl

Deletes a synonym.

Parameters:

synonym_id (required)

Options:

-synonym_id

synonym_id of the synonym to be deleted.

Authors:

Bernd Schmeil <bernd@thebernd.de>

Timo Hentschel <timo@timohentschel.de>

Testcases:

category_synonyms

Source code:

    db_transaction {
    db_exec_plsql delete_synonym ""
    }

Generic XQL file:

packages/categories/tcl/category-synonyms-procs.xql

PostgreSQL XQL file:

<fullquery name="category_synonym::delete.delete_synonym">
    <querytext>
		select category_synonym__del (
				    :synonym_id
				    )
      </querytext>
</fullquery>

packages/categories/tcl/category-synonyms-procs-postgresql.xql

Oracle XQL file:

<fullquery name="category_synonym::delete.delete_synonym">
    <querytext>
		begin
		category_synonym.del (
				      synonym_id   => :synonym_id
				     );
		end;
      </querytext>
</fullquery>

packages/categories/tcl/category-synonyms-procs-oracle.xql