Stored procedure call

Question

Question

瑞王 · Apr 7, 2020

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

Log in or sign up to continue

Cristiano Silva · Apr 7, 2020

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

score 1 · Answer 1 · 2020-04-07T07:08:27-04:00

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 ?

score 0 · Answer 2 · 2020-04-07T07:30:03-04:00

瑞王 · Apr 7, 2020

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

0 0

score 0 · Answer 3 · 2020-04-07T07:55:17-04:00

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

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