Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Problem trying to execute sqlproc inside multiple folders/package

Question
Alice Shrestha · Nov 27, 2020

Problem trying to execute sqlproc inside multiple folders/package

Hi,

I seem to be able to execute sqlproc using the convention defined here https://docs.intersystems.com/latest/csp/docbook/Doc.View.cls?KEY=GSQL_q... provided the package/folder is a single level. As, soon I have a nested folder structure I get an error while trying to execute this. 

For instance, 

select id, Utils.Users_getRole(id) roles from users.users

works fine while, 

select id, com.xyz.utils.Users_getRole(id) from users.users
does not work and gives,  "User defined SQL function ... does not exist"

I am on Cache 2017. Is there a workaround to making this work? 

#Code Snippet #Caché

Source URL:https://community.intersystems.com/post/problem-trying-execute-sqlproc-inside-multiple-folderspackage