-
Sylvain .
- PowerBuilder
- Monday, 1 October 2018 09:06 PM UTC
I'm doing the following codes in powerbuilder 2017 R3 trial,
string as_SQL = "CALL fn_GL_Ledger_Dump('', '', '', '', '', '', '', '', '', '', '', '2018-01-01', '2018-01-301', true, 0)"
EXECUTE IMMEDIATE :as_SQL USING SQLCA ;
when running as a client/server (desktop) it work fine, but when I deploy to PowerServer Web and try the same thing in in a webpage I have the following error:
sqlCode[-1] sqlDBcode[-2147467259] Table 'mysql.proc' doesn't exist
Is it possible that the CALL is not supported when running from a webpage, what is the best way around this?
Thank you in advance for your time...
Sylvain
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.