Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

how to call pl/sql function  in vb .net

Posted on 2012-04-10
2
Medium Priority
?
586 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:
Victor Tarasov earned 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

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…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video shows how to recover a database from a user managed backup
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

916 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