Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the driver beyond simple SELECT operations with Claude Compliance.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Claude Compliance, along with an indication of whether the procedure succeeded or failed.
CData ODBC Driver for Claude Compliance Stored Procedures
| Name | Description |
| CreateActivitySchema | Creates an RSD for one Activity Feed type by sampling a single matching activity. The generated view filters activity_types[] to ActivityType, flattens nested objects, includes type-specific fields from the sample, and preserves variable-length arrays as JSON. |
| CreateSchema | Creates a schema file for the specified table or view. |
| DeleteChat | Permanently deletes a chat and all associated messages and files. This operation cannot be undone. |
| DeleteCodeArtifact | Permanently deletes a Code Artifact and all its versions. |
| DeleteFile | Permanently deletes a user-uploaded chat file. This operation cannot be undone. |
| DeleteProject | Permanently deletes a project and its associated data. The project must not have attached chats. |
| DeleteProjectDocument | Permanently deletes a project document. This operation cannot be undone. |
| DownloadArtifact | Downloads the text content of an artifact by its version Id. |
| DownloadCodeArtifact | Downloads the response body for one retained Claude Code Artifact version. The VersionId is obtained from the CodeArtifactVersions view. |
| DownloadFile | Downloads the raw content of a user-uploaded chat file. |
| DownloadGeneratedFile | Downloads the raw content of a file generated by the Claude assistant. |
| DownloadProjectDocument | Downloads the extracted text content of a project knowledge-base document. |
| GetArtifact | Returns metadata for one artifact version. |
| GetChatFile | Returns metadata for one user-uploaded chat file. |
| GetChatMessageArtifacts | Returns one flattened output row per artifact attached to a chat message. |
| GetChatMessageFiles | Returns one flattened output row per uploaded file attached to a chat message. |
| GetChatMessageGeneratedFiles | Returns one flattened output row per assistant-generated file attached to a chat message. |
| GetGeneratedFile | Returns metadata for one file generated by Claude through tool use. |