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

  • Thread starter Thread starter Si Jingnan
  • Start date Start date
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!
*************************************************
 
Cowboy (Gregory A. Beamer) said:
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).
Click to expand...

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) := :pID;
lName varchar2(50) := :pName;
lTab MyTabType;
BEGIN
lTab.ID = lID;
lTab.Name = lName;

MyProc(lTab);
END;


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

Thanks

Jingnan
 
Si Jingnan said:
Where can I find the PL/SQL block, I check the MSDN web site and nothing
found.
Click to expand...

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

David
 
Back
Top