Ms. Castro:
In the procedure declaration
PROCEDURE CL_CURSOR(p_item in varchar2, P_ICĀ OUT t_row)
the P_IC is referenced as an OUT variable of type t_row. But to use it, it
must be declared somewhere else, usually in the calling program. So, a
variable definition should exist in the package
I declare the t_row here:
CREATE OR REPLACE PACKAGE LAWSON1.PACK_ICTRANS
ASCURSOR c1 ISSELECT ITEM,DOC_TYPE,DOCUMENT FROM
ICTRANS;TYPE t_row IS REF CURSOR RETURN
c1%ROWTYPE; --Declaration
PROCEDURE CL_CURSOR(p_item in varchar2,
P_IC OUT t_row);END
PACK_ICTRANS;Where and how can I declare
You have declared a cursor c1
and then in your code you try and open P_IC
try opening C1
You need to go read the documentation on cursors and learn how they are manipulated as your coding around the usage of the cursor is rather wrong
From The Application Developers Guide - Fundamentals
How are you connecting - if you are using odbc you will need the Oracle
client software.
-Original Message-
Sent: Wednesday, September 26, 2001 10:50 AM
To: Multiple recipients of list ORACLE-L
If I was going to distribute a client VB application connecting to Oracle,
would I need to
You will need to distribute the drivers as well, of course, it depends on
the type of interface, ADO, DAO, OLE.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence
Oracle DBA
Phone:
We will be connecting OLEDB...
-Original Message-
B
Sent: Wednesday, September 26, 2001 12:55 PM
To: Multiple recipients of list ORACLE-L
How are you connecting - if you are using odbc you will need the Oracle
client software.
-Original Message-
Sent: Wednesday, September 26,