how to call pl/sql function in vb .net
Posted on 2012-04-10
I am trying to create a VB .net DLL to handle all the pl/sql package code that we have developed.
here is an example of a function call that I want the the dll to be able to wrap around and then return the result to the caller
(i_PS_CITY IN WMIS.WR_POINT_SPAN.PS_CITY@TEG_WMIS.INTEGRYSGROUP.NET%TYPE
) RETURN TEG.SPCKG_AEC_DATA_TYPES_WMIS_TEG.TEG_AEC_CITY_REC;
1st I need a way in the VB dll to be able to read the %TYPE that you can set in oracle to have that be the variable.
so the i_PS_CITY input variable is of a datatype WMIS.WR_POINT_SPAN.PS_CITY@TEG_WMIS.INTEGRYSGROUP.NET%TYPE
and this could change, when it does i need the dll to pick up what ever is the current datatype defined in the database.
2nd the return variable TEG.SPCKG_AEC_DATA_TYPES_WMIS_TEG.TEG_AEC_CITY_REC
is a %rowtype from oracle. The actual definition of the oracle row is defined in the
TEG.SPCKG_AEC_DATA_TYPES_WMIS_TEG pl/sql package.
I am trying to avoid hard coding the variable types, i am trying to look for a solution that will always connect to the database and determine what the datatype should be ...
If this really can not be done please let me know so I dont really waste the time trying to find a solution.