Database reference - demo

demo -  procedures -  ml_server.ml_delete_device_address

Description

none

Procedure properties

namevalue
nameml_server.ml_delete_device_address 
created 
typeSQL stored procedure 

Parameters

namedatatypelengthin/outcomment
@devicevarchar255in 
@mediumvarchar255in 


Usage

EXEC ml_server.ml_delete_device_address
    @device = @myvarchar1,
    @medium = @myvarchar2

Dependency graph

ml_device_addressml_delete_device_address

Objects that ml_server.ml_delete_device_address depends on

nameobject typelevel
ml_device_addresstable1

Code

create procedure ml_server.ml_delete_device_address( 
  in @device varchar(255),
  in @medium varchar(255) ) 
begin
  delete from ml_device_address where device_name = @device and medium = @medium
end



Documentation generated by SqlSpec