Stored Procedures in Cognos Framework Managger (Continued...)
Or
If
you want to convert it to a function, use f(x)
convert option
You
can see it in the package definition as follows.
1 comment:
Anonymous
said...
Hello,
I am trying to do this using Oracle. I have a Procedure created in Oracle and it's in a Package, which it says in the documentation that it must be. I can run my Package in Oracle and get my results. My problem is that the result set is coming into Framework Manager as a Binary data type, which is not allowed. It also says that Out parameters are not allowed, but I don't think I can write the Procedure without the Out param for the result set. Can you help me? I can clearly see how this is done using Microsoft SQL, but unfortunately we use Oracle SQL.
1 comment:
Hello,
I am trying to do this using Oracle. I have a Procedure created in Oracle and it's in a Package, which it says in the documentation that it must be. I can run my Package in Oracle and get my results. My problem is that the result set is coming into Framework Manager as a Binary data type, which is not allowed. It also says that Out parameters are not allowed, but I don't think I can write the Procedure without the Out param for the result set. Can you help me? I can clearly see how this is done using Microsoft SQL, but unfortunately we use Oracle SQL.
Deborah
Post a Comment