Thank u very much. I could execute my stored procedures.
-Nav
----- Original Message -----
From: <jrodrigues@s...>
To: professional vb <pro_vb@p...>
Sent: Tuesday, December 18, 2001 12:12 PM
Subject: [pro_vb] Re: Executing ORACLE stored procedure in VB


> Sorry,
>
> Where you wrote:
>
> Create or REPLACE PROCEDURE getSalary(Cursorout out ExpCursor)
>
> Write:
>
> Create or REPLACE PROCEDURE getSalary(Cursorout out PKG_EXP.ExpCursor)
>
> You must tell where found the EXPCURSOR.
>
> Juliano
>
> > I could create a package but when I tryied to create stored Procedure it
> is
> > giving me an error
> > 1/35     PLS-00201: identifier 'EXPCURSOR' must be declared
> > So I couldn't create stored procedure
> >
> > -Naveen
> > ----- Original Message -----
> > From: <jrodrigues@s...>
> > To: professional vb <pro_vb@p...>
> > Sent: Monday, December 17, 2001 4:59 PM
> > Subject: [pro_vb] Re: Executing ORACLE stored procedure in VB
> >
> >
> > > Let´s try again:
> > >
> > > The Procedure is in the wrong place. Your package must be:
> > >
> > > CREATE or REPLACE PACKAGE PKG_EXP
> > > AS
> > > Type ExpCursor is ref cursor;
> > > END PKG_EXP;
> > > /
> > >
> > > And your Stored Procedure:
> > >
> > > Create or REPLACE PROCEDURE getSalary(Cursorout out ExpCursor)
> > >  IS
> > >  BEGIN
> > >    OPEN Cursorout for
> > >    SELECT GRADE,
> > >     LOSAL,
> > >     HISAL
> > >    FROM SALGRADE;
> > >  END getSalary;
> > > /
> > >
> > >
> > > Juliano Moraes Rodrigues
> > > Analista de Sistemas - FA Consult
> > > juliano.rodrigues@f...
> > > (019) 9719-2417
> > > São Paulo - Brasil
> > >
> > >
> > >
> > > > Regarding the point 1,
> > > > CREATE or REPLACE PACKAGE PKG_EXP
> > > > AS
> > > > Type ExpCursor is ref cursor;
> > > > PROCEDURE getSalary(Cursorout out ExpCursor)
> > > > IS
> > > > BEGIN
> > > >   OPEN Cursorout for
> > > >   SELECT GRADE,
> > > >    LOSAL,
> > > >    HISAL
> > > >   FROM SALGRADE;
> > > > END getSalary;
> > > > END PKG_EXP;
> > > > /
> > > > It is not creating package, As I am new to ORACLE I don't know whats
> > > wrong
> > > > in it.
> > > > Regarding the point 3, I tried with Resultset 0, it is not working.
> > > > I'm using ORACLE 8.1.6.0.0 Version, I'm herewith sending the message
> > > > displayed when I opened ORACLE client.
> > > > SQL*Plus: Release 8.1.6.0.0 - Production on Mon Dec 17 21:24:40 2001
> > > >
> > > > (c) Copyright 1999 Oracle Corporation.  All rights reserved.
> > > >
> > > >
> > > > Connected to:
> > > > Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
> > > > With the Partitioning option
> > > > JServer Release 8.1.6.0.0 - Production
> > > >
> > > >
> > > >
> > > > -Naveen
> > >
$subst('Email.Unsub').
> >
>