Oracle Package and Procedure

[André Nobre]

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_AUX 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_CLI,
A.sDESCLSCRD_CLI,
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;

[Cor Ligthert]

Andre,

The ones who like to give answers on Oracle problems are almost all more or
less active in this newsgroup.

Adonet
news://msnews.microsoft.com/microsof...amework.adonet

Web interface:
http://communities2.microsoft.com/co...amework.adonet

With what I don't say that all who are active in that newsgroup like to give
answers on Oracle questions.

I hope this helps,

Cor

[Doug Taylor]

On Fri, 06 May 2005 15:59:16 -0300, André Nobre <[e-mail]> 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_AUX 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_CLI,
A.sDESCLSCRD_CLI,
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