Creating the Distance() function

To create the Distance() function:

  1. Choose Edit > Insert > Routine and type the following information in the New Routine wizard.
    Routine Property Value
    Routine Name (SQL) Distance
    Language C
    Return type double precision
    Statement Local Variables No
    Arguments
    • Name: Pnt1, Type: Pnt, Default: leave blank
    • Name: Pnt2, Type: Pnt, Default: leave blank
    Options for how the database server calls this routine Only the Routine does not accept NULL arguments check box must be checked; clear the Routine may return inconsistent check box.
    Routine Name (C) Distance
    Shared object path Leave as default
    Behavior of Routines Well-behaved
    Special Stack Requirements None
    Cost of a Routine 0
    Related Routines None
    Object grant privileges Grant execute privileges
  2. Click Finish and then choose Project > Save to save your project.
Parent topic: Tutorial exercise 4: Creating opaque data types
Copyright© 2019 HCL Technologies Limited