Solved

how to call pl/sql function  in vb .net

Posted on 2012-04-10
2
541 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
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Fastest way to replace data in Oracle 5 51
Vb.net dynamic formulas in runtime 11 62
Help with Syntax 9 28
Shredding xml into an oracle 11g Database 2 29
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

896 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now