sql: Support CALL statements for pausable portals

[ZhouXing19]

In Postgres, pausable portal is supported with CALL statement with store procedures. E.g.:

send
Parse {"Name": "foo", "Query": "CALL fab5()"}
Bind {"DestinationPortal": "foo", "PreparedStatement": "foo"}
Bind {"DestinationPortal": "foo2", "PreparedStatement": "foo"}
Execute {"Portal": "foo", "MaxRows": 100}
Sync
----

# PG allows procedure with pausable portal, but CRDB does not.
until noncrdb_only ignore=RowDescription ignore=NoticeResponse
ReadyForQuery
----
{"Type":"ParseComplete"}
{"Type":"BindComplete"}
{"Type":"BindComplete"}
{"Type":"CommandComplete","CommandTag":"CALL"}
{"Type":"ReadyForQuery","TxStatus":"I"}

We now disallow it in #151153.

Jira issue: CRDB-53331