Written by

Question 瑞王 · Apr 7, 2020

Stored procedure call

#Caché #InterSystems IRIS #SQL

When using CallableStatement to call a stored procedure, the log shows an error. SqlCode-400.

This is my calling statement.

CALL web_DHCENS_CDSS.patadviceinfo_patadviceinfo(?,?,?)

Discussion (4)2

Add reply

Comments

Cristiano Silva · Apr 7, 2020

Hi,

The error occour in the line:

zPATADVICEINFOExecute+15^web.DHCENS.CDSS.PARADVINCEINFO.1

When try to access the global ^PAADMi("No", ""), the error occours because is trying to acces a null subscript.

Maybe a parameter was not passed in the procedure call ?

0 0

瑞王 Apr 7, 2020 to Cristiano Silva

写法如下，我打印出有三个参数传入，其中一个空字符串，两个日期

0 0

Marc Mundt Apr 7, 2020 to 瑞王

这三个参数有什么用途？^PAADMi("No") 是医院episode号码的指数。空字符串的参数会不会需要episode号？

最好要修改stored procedure先检查需要的参数。

0 0

Cristiano Silva Apr 7, 2020 to 瑞王

The global ^PAADMi("No", "") is a index global, if I'm not wrong ,is a index of PA_AADM table and the field of the index is PAADM_PAPMI_NO (MRN number of patient). Maybe then idex have some problem.

Do you have access to the stored procedure code?, If yes try to execute the query of procedure manually in the System Adminstration Portal. If not, I think you will need some suport.

0 0