Sign inTry Free
  • Introduction
    • Deploy
      • Connect to Your Cluster
        • Create a Database
          • Integrate with SingleStoreDB
            • Load Data
              • Query Data
                • Manage Data
                  • Developer Resources
                    • Migrate Existing Applications
                      • Connect with Application Development Tools
                        • Data API
                        • Concurrent Multi-Insert Examples
                          • Functional Extensions
                            • Procedural Extensions
                              • Performance
                              • Control Flow
                              • Additional Data Types
                              • Stored Procedures
                              • User-Defined Scalar-Valued Functions (UDFs)
                              • User-Defined Table-Valued Functions (TVFs)
                              • User-Defined Aggregate Functions (UDAFs)
                              • External Functions
                              • Static Parameterized SQL
                              • Dynamic SQL
                                • Procedural Extensions Security
                                • Procedural SQL Reference
                                • See Also
                              • Get Started Using SingleStoreDB for Free
                                • See Also
                              • User and Cluster Administration
                                • Reference
                                  • Security
                                    • Release Notes
                                      • Support
                                        • Glossary
                                        1. Self-Managed v8.0
                                        2. /
                                        3. ...
                                        4. /
                                        5. Additional Data Types

                                        Additional Data Types

                                        Stored procedures and UDFs can use ARRAY and RECORD types by accepting them as input parameters, creating and manipulating them in the procedure or UDF definition, and optionally returning them as a return type. Stored procedures can also use QUERY types.

                                        Last modified: April 24, 2021

                                        Was this article helpful?

                                        Control Flow
                                        Stored Procedures

                                        Product

                                        • Product Overview
                                        • Solutions
                                        • Pricing
                                        • Support

                                        Community

                                        • Forums
                                        • Developer Hub
                                        • Events
                                        • Training

                                        Company

                                        • Contact Us
                                        • Blog
                                        • Careers
                                        • SingleStore Connect

                                        This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

                                        • © SingleStore
                                        • |

                                        • Privacy Policy
                                        • |

                                        • Terms of Service
                                        • |

                                        • Legal Terms and Conditions

                                        Was this article helpful?