Is it possible to call packaged Oracle functions using the Database Toolbox 3.2 (R2006b)?

2011 1 16
1 个回答
3 次查看（30 天）

回答（1 个）

Sanchali Purandare
Sanchali Purandare 2011-1-16

1 个投票

You may call the functions in your package using the syntax of
.
Thus, when using the connection called myconn, if your function is called myfunction and it is in the package called mypackage, then here are two ways of calling it:
exec (myconn, 'mypackage.myfunction')
or
runstoredprocedure(myconn, 'mypackage.myfunction')
If your packaged function returns values or needs input parameters then you need to use the RUNSTOREDPROCEDURE function with an input parameter specified as a cell array and a specified return type. To see an example of this, execute the following at the MATLAB command prompt:
doc runstoredprocedure
and examine the second and third examples.

类别

在 帮助中心 和 File Exchange 中查找有关 Database Toolbox 的更多信息

产品

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by