Can we read input text file within the stored procedure in MemSQL?

Use Case is like :- we have one java application with sql server database and database side we have one procedure where we are reading input file and validating file and storing in database and based upon validation results we are returning status code to java application?

Can we achieve this kind of synchronous functionality in Memsql? (As per my knowledge pipeline is Asynchronous process and we can not create pipeline in SP)
Please suggest?

Any thoughts on this??

The best way to synchronously load a file in this case would be to use the LOAD DATA command. See https://docs.memsql.com/v7.1/reference/sql-reference/data-manipulation-language-dml/load-data/ for more details.