naveenayalla
New Contributor III

Databricks stored procedures currently support LANGUAGE SQL, not LANGUAGE PYTHON, so that error is expected. Docs show CREATE PROCEDURE supports LANGUAGE SQL only, on DBR 17.0+ with Unity Catalog.