How can I call an Oracle store procedure who has a paremter whichis a table type?

[Si Jingnan]

As the subject.

Thanks
Jingnan Si

 

[Cowboy \(Gregory A. Beamer\)]

ODP.NET from Oracle (free download). The standard MS libraries do not
support table types as input, at least not in 1.1 (have not played with
Oracle in 2.0 yet).

--
Gregory A. Beamer

*************************************************
Think Outside the Box!
*************************************************

 

[David Browne]

ODP.NET from Oracle (free download). The standard MS libraries do not
support table types as input, at least not in 1.1 (have not played with
Oracle in 2.0 yet).

Also you can send a PL/SQL block down from the MS provider. Being pure
PL/SQL it can use the table type, but it must communcate with .NET through
scalar bind variables.


EG Use an OracleCommand with a commandText something like


DECARE
lID number(9) := ID;
lName varchar2(50) := Name;
lTab MyTabType;
BEGIN
lTab.ID = lID;
lTab.Name = lName;

MyProc(lTab);
END;


David

 

[Si Jingnan]

Where can I find the PL/SQL block, I check the MSDN web site and nothing
found.

Thanks

Jingnan

 

[David Browne]

Where can I find the PL/SQL block, I check the MSDN web site and nothing
found.

PL/SQL is Oracle's programming language. It's documented at Oracle's web
site.

David