All Forums General
vic.miranda 1 post Joined 10/10
26 Feb 2015
JSXP FileOutputStream working in VM not working in Production

I have an external procedure that I have been working on that Mimics ORACLE's DBMS OUTPUT using FileOutputStream. It works fine in my TD VM but does not work in our Production box. Do you guys know any restriction that we have on a production box that will prevent FileOutputStream from executing?
I tried deploying the JSXP in both Eclipse and from the command line. In both instances it works fine on our VM but does nothing on our Production box.
Hope to hear from you guys.
Thank you very much

Fred 1096 posts Joined 08/04
27 Feb 2015

A Stored Procedure invocation can potentially execute on any one of the database server nodes, each of which has its own independent OS filesystem. You say it does nothing, but perhaps you are simply not looking in the right place.
In the case of the Teradata Express VM, there is only a single virtual node - so the SP must always execute on that same node.

You must sign in to leave a comment.