Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
languagesql
var clientId varchar2(50)
var clientCompany varchar2(50)
var clientStreet varchar2(50)
var clientPostalCode varchar2(15)
var clientCity varchar2(50)
var clientCountry varchar2(50)
var clientDescription varchar2(200)
var cultureInfoId number
var clientLogo varchar2(255)
var clientFlags number
var userid varchar2(50)
var insertFlag number
var updatemask number
var retval number

exec :clientId := '01'
exec :clientCompany := 'XIMES'
exec :clientStreet := 'Hollandstrasse 12/12'
exec :clientPostalCode := '1020'
exec :clientCity := 'Wien'
exec :clientCountry := 'Austria'
exec :clientDescription := 'XIMES01'
exec :cultureInfoId := 1
exec :clientLogo := null
exec :clientFlags := 0
exec :userid := null'TISAdmin'
exec :insertFlag := 1
exec :updatemask := 0

exec ximes_dal.xiSp_SaveClient(ClientId_in => :clientId, -
                               ClientCompany_in => :clientCompany, -
                               ClientStreet_in => :clientStreet, -
                               ClientPostalCode_in => :clientPostalCode, -
                               ClientCity_in => :clientCity, -
                               ClientCountry_in => :clientCountry, -
                               ClientDescription_in => :clientDescription, -
                               CultureInfoId_in => :cultureInfoId, -
                               ClientLogo_in => :clientLogo, -
                               ClientFlags_in => :clientFlags, -
                               UserId_in => :userId, -
                               insertflag => :insertFlag, -
                               updatemask => :updatemask, -
                               retval_out => :retval);

commit;

...