I don't know if this is the right place to make this question, so, if
isn't, let me know...
I have an oracle package with some procedures, and i need to access one
procedure using vb.net. The problem is that i really don't know what
this oracle procedure will return to vb.net. If I execute this normally,
like ADO.NET Store Procedure, i'll get a DataSet/DataTable? What should
i pass as parameter to "cC1" (in out - procedure
P_G_CLI_I8)?
Thanks,
André Nobre
Here's my oracle code:
create or replace package oraims.K_G_CLI_ I8
as
--------------------------------------------------------------------------------------------------------------------
xDATAHORA date;
sCGC_BASE_CLI_A UX varchar2(9);
cursor C1 is select A.sCGCCPF_CLI,
A.sNOME_CLI,
A.sFAX_CLI,
A.nCODDOCFALTA,
A.nCLSCRD_CLI,
A.bINDCOR,
A.xDATAULTALT,
A.yHORAULTALT,
A.sEND_CLI,
A.sNROEND_CLI,
A.sCOMEND_CLI,
A.sBAI_CLI,
A.sCEP_CLI,
A.sCID_CLI,
A.sUF_CLI,
A.sENDTLX,
A.sIDFCLSCRD_CL I,
A.sDESCLSCRD_CL I,
B.nCODBCO,
B.nCODAGE,
B.nCONTACOR,
B.nREGIAO,
B.nDICOM,
B.nSEGMER,
B.sSEGMER
from TBCDCLI8 A,
TBCDRCL8 B;
type tC1 is ref cursor return C1%rowtype;
--------------------------------------------------------------------------------------------------------------------
procedure P_G_CLI_I8
(
nTIPO_IO in number,
cC1 in out tC1
);
end K_G_CLI_I8; 2 3015
On Fri, 06 May 2005 15:59:16 -0300, André Nobre <no@spam.com> wrote: I don't know if this is the right place to make this question, so, if isn't, let me know...
I have an oracle package with some procedures, and i need to access one procedure using vb.net. The problem is that i really don't know what this oracle procedure will return to vb.net. If I execute this normally, like ADO.NET Store Procedure, i'll get a DataSet/DataTable? What should i pass as parameter to "cC1" (in out - procedure P_G_CLI_I8)?
Thanks, André Nobre
Here's my oracle code:
create or replace package oraims.K_G_CLI_ I8 as -------------------------------------------------------------------------------------------------------------------- xDATAHORA date; sCGC_BASE_CLI_A UX varchar2(9); cursor C1 is select A.sCGCCPF_CLI, A.sNOME_CLI, A.sFAX_CLI, A.nCODDOCFALTA, A.nCLSCRD_CLI, A.bINDCOR, A.xDATAULTALT, A.yHORAULTALT, A.sEND_CLI, A.sNROEND_CLI, A.sCOMEND_CLI, A.sBAI_CLI, A.sCEP_CLI, A.sCID_CLI, A.sUF_CLI, A.sENDTLX, A.sIDFCLSCRD_CL I, A.sDESCLSCRD_CL I, B.nCODBCO, B.nCODAGE, B.nCONTACOR, B.nREGIAO, B.nDICOM, B.nSEGMER, B.sSEGMER from TBCDCLI8 A, TBCDRCL8 B; type tC1 is ref cursor return C1%rowtype; -------------------------------------------------------------------------------------------------------------------- procedure P_G_CLI_I8 ( nTIPO_IO in number, cC1 in out tC1 ); end K_G_CLI_I8;
Assuming you are using the Oracle Data provider for your connectivity
I suggest that you read the documentation on using Cursors in the help
files provided, there are too many details to go into here.
Though a quick summary is you should use a command object with a
stored procedure as its type and then set the return parameter as
being a cursor, as I say it is well documented in the Oracle data
provider help files, which I unfortunately don't have installed on
this machine.
Doug Taylor This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: s_gemberling |
last post by:
I am connecting to Oracle 9i via an ASP page using the ORacle OLEdB
driver (OraOLEDB). When I try to execute the following vbscript code
in ASP my page hangs(no timeouts, no errors, etc.) It just looks like
it is still retreiving the page. I have run the SQL statement directly
in SQL plus and it runs run. I executed the package from sql
plus...it too runs fine. There is only 1 record in the table so too
much data is not an issue. When I...
|
by: s_gemberling |
last post by:
Here is the code that calls the Oracle package:
Function b_GetRecords(sTableName, sRecordName)
on error resume next
dim cmd, objParameter
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open cst_Tasks_ConnectionString
|
by: Jason Leiser |
last post by:
Is there a way to call an Oracle Procedure using the MS OLD DB Provider
for Oracle object in a SQL Server 2000 DTS package? If it can't be done
this way, is there another way to retrieve data from an Oracle database
using an Oracle procedure to a SQL Server table? Also, can parameters
be passed into Oracle from SQL Server via a procedure? Our Oracle DBA
does NOT want to create views to enable SQL Server to access the data.
Examples...
|
by: robin via SQLMonster.com |
last post by:
I've tried several different way to execute a oracle stored
procedure from a DTS package but to no avail.
I have a Linked Server setup which does bring back Oracle tables from the
server when I click on the Tables icon.
Here's my DTS statement:
exec omsd..OMS_TECO.SP_Callback_Update_Pkg(116);
omsd is the linked server
|
by: Brew |
last post by:
Hello,
I'm writing an ASP.NET 2005 (VB) Website with an Oracle 9i backend
I have an oracle package with stored procedures and functions I need to
use from the
VB Code, I'm trying to use the SQLDataSource to call a stored procedure
passing parameters and then displaying the results on a GridView
control my trouble is with the parameters and displaying results into
the GridView.
| |
by: george |
last post by:
Hi world!
Anyone experienced building gridview in Oracle environment using stored
procedures, please help!
Right now, I have issues using Oracle SP, I spent a whole day on this
and still cannot get the results back, so shamelessly turn to you for
help!
OK, the web page part of SqlDataSource is defined as:
<asp:SqlDataSource ID="SqlDataSource4" runat="server"
|
by: ssp |
last post by:
Hello there,
I am trying to do very simple thing in trying to return results from an
Oracle (10g) Stored Procedure using the Enterprise Library June 2005
Version.
The stored procedure first:
============================================
CREATE OR REPLACE PROCEDURE AGENCYSELECTALL(p_cursor OUT
SelectPackage.SelectCursor)
|
by: cetram |
last post by:
Hello!
I'm trying to fix an appliaction created using ColdFusion MX and Oracle 9i. The application worked fine until our IT department reinstalled the oracle server. As far as I've been able to see.
The CF application calls to a stored procedure in a package on the Oracle server. However, when the CF application attempts invoce the stored procedure, I get the following error message:
PLS-00306 wrong number or types of arguments in call...
|
by: mh |
last post by:
I'm pleased to announce the initial release of OraPIG,
the Oracle Python Interface Generator.
OraPIG generates Python wrapper classes for Oracle packages.
If you use Oracle and Python, this might be a pretty useful
package for you. Download it and let us know what
you think!
Cheers,
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |