Regarding stored procedures

Helli sir,
can help me with, how to create stored procedures in dremio?

@Vijay1 Dremio does not support anything similar to Oracle PL/SQL yet, you can however call stored procedures via external queries

sir, can you please elaborate it, how we can do it in dremio. do we have to import stored procedures to dremio and then can we call using external queries.

Can you please give me an example of it sir.

Thank you

@Vijay1 You can try using external queries and in the external query, execute the stored procedure

can you please elaborate it sir?