Call an Oracle Stored Procedure from an AQL

[danstenzel]

Does anyone know how to call a Stored Procedure (we are using Oracle) from an AQL?

Here is an example of an AQL we run using this (editted to remove sensitive information) command:

amexpl -script:/querylib/export.aql -cnx:ACOracle -login:nylogin -password:xxxxx -log:/tmp/acexport_script.log -overwrite

{ Export_script_version 301
  Action=0
  CreateFile=0
  FileSql="C:\\PROGRA~1\\PEREGR~1\\ASSETC~1\\export.sql"
  Separator=;
  { Options
    Title=0
    TextSep=9
    TextId=0
    NumSep=46
    Output=ANSI
    DateOrder=0
    DateSep=47
    LongYear=1
    TimeSep=58
    Seconds=0
    DropFullNameSlash=1
    InsertComment=0
    CreateStrFile=0
  }
  { Line AgencyCodes
    SQL="SELECT AgencyCode, AgencyName, AgencySubCode, AgencySubName FROM amAgencyCodes ORDER BY AgencyCode, AgencySubCode"
    File=/tmp/Agency_Codes
    StrFile=
    Comment=
  }
}

as an addendum to the question about Stored Procedures ... is there a way to access an Oracle View?

Does it have to be defined to Asset Center some how?

Thanks - Dan