Can we call a stored procedure inside the View in Netezza?
我们可以在Netezza中的View中调用存储过程吗?
I am doing Oracle to Netezza Migration.
我正在为Netezza Migration做Oracle。
We have a view in Netezza that uses CONNECT BY ROOT.
我们在Netezza中有一个使用CONNECT BY ROOT的视图。
To replicate CONNECT BY ROOT, we have written a stored procedure.
为了复制CONNECT BY ROOT,我们编写了一个存储过程。
How to call that stored procedure from a view?
如何从视图中调用该存储过程?
1 个解决方案
#1
While stored procedures can be called with a SELECT form, I don't think they can be called that way from within a view.
虽然可以使用SELECT表单调用存储过程,但我认为它们不能从视图中以这种方式调用。
#1
While stored procedures can be called with a SELECT form, I don't think they can be called that way from within a view.
虽然可以使用SELECT表单调用存储过程,但我认为它们不能从视图中以这种方式调用。