Solved

how to call pl/sql function  in vb .net

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle Verification of DataPump Export and Import 17 55
VB.NET 1 22
get column names from table in vb.net 8 28
Database Connections Not being returned to Connection Pool 7 25
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Via a live example, show how to take different types of Oracle backups using RMAN.
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.

770 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