Jump to

• Request
• Response
• Examples

Execute SDO_GEOR_ADMIN Package Functions

post

{server}/georaster/v1/{datasource}/sdo_geor_admin/{functionName}

Execute MDSYS.SDO_GEOR_ADMIN package functions with the specified function names. The parameters to the function is specified in the request body in JSON. See Spatial GeoRaster Developer's Guide for the usage of each function and its parameters.

Request

Path Parameters

• functionName(required): string
  The name of the functions in SDO_GEOR_ADMIN package

  Allowed Values: [ "checksysdataentries", "getuniquerdtname", "isgeorasterenabled", "isrdtnameunique", "listdanglingrasterdata", "listgeorastercolumns", "listgeorasterobjects", "listgeorastertables", "listrdt", "listregisteredrdt", "listunregisteredrdt", "maintainsysdataentries", "registergeorastercolumns", "registergeorasterobjects" ]

Supported Media Types

• application/json

Request Body - application/json ()

Root Schema : schema

Match One Schema

Show Source

• object isrdtnameunique_param
• object listgeorastercolumns_param
• object listgeorasterobjects_param
• object registergeorastercolumns_param
• object registergeorasterobjects_param

{
    "oneOf":[
        {
            "$ref":"#/components/schemas/isrdtnameunique_param"
        },
        {
            "$ref":"#/components/schemas/listgeorastercolumns_param"
        },
        {
            "$ref":"#/components/schemas/listgeorasterobjects_param"
        },
        {
            "$ref":"#/components/schemas/registergeorastercolumns_param"
        },
        {
            "$ref":"#/components/schemas/registergeorasterobjects_param"
        }
    ]
}

Nested Schema : isrdtnameunique_param

Type: object

Show Source

• rdtname(required): string

{
    "type":"object",
    "properties":{
        "rdtname":{
            "type":"string"
        }
    },
    "required":[
        "rdtname"
    ]
}

Nested Schema : listgeorastercolumns_param

Type: object

Show Source

• list_option: string
• table_name: string

{
    "type":"object",
    "properties":{
        "list_option":{
            "type":"string"
        },
        "table_name":{
            "type":"string"
        }
    }
}

Nested Schema : listgeorasterobjects_param

Type: object

Show Source

• list_option: string
• table_name: string

{
    "type":"object",
    "properties":{
        "list_option":{
            "type":"string"
        },
        "table_name":{
            "type":"string"
        }
    }
}

Nested Schema : registergeorastercolumns_param

Type: object

Show Source

• table_name: string

{
    "type":"object",
    "properties":{
        "table_name":{
            "type":"string"
        }
    }
}

Nested Schema : registergeorasterobjects_param

Type: object

Show Source

• table_name: string

{
    "type":"object",
    "properties":{
        "table_name":{
            "type":"string"
        }
    }
}

Back to Top

Response

200 Response

Result of the function

Body ()

Root Schema : functionReturn

Type: object

Show Source

• ReturnStatus: string
• ReturnValue: ReturnValue

{
    "type":"object",
    "properties":{
        "ReturnStatus":{
            "type":"string"
        },
        "ReturnValue":{
            "oneOf":[
                {
                    "type":"integer"
                },
                {
                    "type":"number"
                },
                {
                    "type":"string"
                },
                {
                    "$ref":"#/components/schemas/sdo_number_array"
                },
                {
                    "$ref":"#/components/schemas/sdo_string2_array"
                },
                {
                    "$ref":"#/components/schemas/sdo_string2_arrayset"
                },
                {
                    "$ref":"#/components/schemas/sdo_geometry"
                }
            ]
        }
    }
}

Nested Schema : ReturnValue

Match One Schema

Show Source

• integer
• number
• string
• array sdo_number_array
• array sdo_string2_array
• array sdo_string2_arrayset
• object sdo_geometry

{
    "oneOf":[
        {
            "type":"integer"
        },
        {
            "type":"number"
        },
        {
            "type":"string"
        },
        {
            "$ref":"#/components/schemas/sdo_number_array"
        },
        {
            "$ref":"#/components/schemas/sdo_string2_array"
        },
        {
            "$ref":"#/components/schemas/sdo_string2_arrayset"
        },
        {
            "$ref":"#/components/schemas/sdo_geometry"
        }
    ]
}

Nested Schema : sdo_number_array

Type: array

Show Source

• Array of: number

{
    "type":"array",
    "items":{
        "type":"number"
    }
}

Nested Schema : sdo_string2_array

Type: array

Show Source

• Array of: string

{
    "type":"array",
    "items":{
        "type":"string"
    }
}

Nested Schema : sdo_string2_arrayset

Type: array

Show Source

• Array of: array sdo_string2_array

{
    "type":"array",
    "items":{
        "$ref":"#/components/schemas/sdo_string2_array"
    }
}

Nested Schema : sdo_geometry

Type: object

Show Source

• attr: string

{
    "type":"object",
    "properties":{
        "attr":{
            "type":"string"
        }
    }
}

401 Response

Authentication information is missing or invalid

Headers

• WWW_Authenticate:

Back to Top

Examples

The following is an example on how to list GeoRaster column by submitting a POST request using cURL.

curl -X POST "https://localhost:8080/oraclespatial/georaster/v1/datasource1/sdo_geor_admin/listGeorasterColumns" -H "Cookie: JSESSIONID=<jsessionid_value>"

The following is an example of a response body for the above request:

{
   "ReturnStatus" : "Success",
   "ReturnValue" : [ [ "IMAGE_TABLE", "IMAGE", "registered" ] ]
}

Back to Top