RPCs Processed by ECDA Option for Oracle

ECDA Option for Oracle handles a set of RPCs.

• When executing stored procedures from within Adaptive Server, use this syntax:

  server_name... sp_proc-name

• When executing stored procedures from the ECDA Option for Oracle, the stored procedure must be executed with the exec syntax as follows:

  exec sp_proc-name

• sp_addservice
  sp_addservice adds a new service to the ECDA Option for Oracle and writes the service entry into the configuration file.
• sp_columns
  sp_columns returns information about the type of data that can be stored in one or more columns.
• sp_configure
  sp_configure displays or changes ECDA Option for Oracle configuration properties.
• sp_dropservice
  sp_dropservice removes an existing service from the ECDA Option for Oracle and deletes the service entry from the configuration file.
• sp_ps
  sp_ps returns detailed status information on specified Open Server threads.
• sp_shutdown
  sp_shutdown shuts down ECDA Option for Oracle.
• sp_statistics
  sp_statistics returns a list of indexes on a single table.
• sp_stored_procedures
  sp_stored_procedures returns information about one or more stored procedures.
• sp_tables
  sp_tables returns a list of objects that can appear in a from clause.
• sp_terminate
  sp_terminate terminates an Open Server thread.
• sp_traceon
  sp_traceon turns on trace flags for the current connection.
• sp_traceoff
  sp_traceoff turns off trace flags for the current connection.
• sp_who
  sp_who returns status information for specified Open Server threads.