Solved

how to call pl/sql function  in vb .net

Posted on 2012-04-10
2
559 Views
Last Modified: 2012-04-12
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


FUNCTION GET_TEG_AEC_CITY_R
      (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.
0
Comment
Question by:jhacharya
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 4

Accepted Solution

by:
VictorTarasov earned 500 total points
ID: 37828560
Try this. Use cursor as output type


or this
0
 
LVL 2

Author Closing Comment

by:jhacharya
ID: 37839387
yep seems to work
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

710 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question