Calling Oracle Procedure inside package

I tried to find it in  <a href=http://www.youtube.com> youtube </a>  www.youtube.com/watch  but had no luck.

I think you could make or replace the package body Scalar test so as to get the result. Anyway, the method by which one has to create the Custom Oracle data client driver is really tasking and one has to go a long way before getting it done. So, I would not suggest anyone to go forward with that technique. If you are looking to call procedure with the package name, the best bet for you would be to move on with the first method!

http://raidious.com

Well i made some syntax error sorry for that(I was in a hurry)

The correction(better later than never:))

1.

create or replace package body ScalarTest as

function GetNumberOfRows return integer is

numberOfRows int;

begin

select count(*) into numberOfRows from publication;

return numberOfRows;

end;

2. A function should be call as {? = call mypackage.functionName}

All the best!

Glad that you could find it usefull.

Here is another way that i discover to call a function that return a scalar value.

Supposing that we have:

create or replace package body ScalarTest as

function GetNumberOfRows return int is

numberOfRows int;

begin

--Publication is a table

select count(*) as TotalRows from Publication;

end;

end;

<sql-query name="ScalarTest" callable="true">

<return-scalar column="TotalRows" type="System.Int32"/>

 select scalartest.getnumberofrows as TotalRows from dual

</sql-query>

When you call session.GetNamedQuery("ScalarTest").UniqueResult<int>() it will return the number of rows.

Hope you find this usefull too.

Hi Paul,

Thanks for the reply.Your solution works gr8.