Solved

how to call pl/sql function  in vb .net

Posted on 2012-04-10
2
571 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:
Victor Tarasov 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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses

617 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