• Subject: ORacle Access Manager
  • From: Ravi <ravi@xxxxxxxxxxxxx>
  • Date: Wed, 20 Jan 1999 13:55:33 -0600

Hello all, 

I am trying to select records from Oracle using Oracle Access Manager. I
have created embedded SQL ILE RPG programs to do this.
My cursor is defined as follows:
 C*                                         
 C/EXEC SQL                                 
 C+   DECLARE get_data CURSOR for           
 C+   SELECT   MODEL_NO,                    
 C+            CATALOG_NO,                  
 C+            DISTRIBUTION_NO,             
 C+            DESCRIPTION_1_TXT,           
 C+            DESCRIPTION_2_TXT            
 C+     FROM   EPR_VIEW_ATLAS_ITEM          
 C+     WHERE  MFG_NO = :ITEM#              
 C+     AND    HIBC_LIC_PROD_NO = :HIBC#    
 C*                             

I am able to connect to the remote system without a problem. I can
select records from ORacle when I use literals in the WHERE clause. The
problem arises when I use host variables in the WHERE clause. No records
are selected. The host variables  are defined in my RPG as Char and 15
long.  In Oracle the corresponding columns are defined as VARCHAR2 and
15 long. No errors are generated by the program. Is there a datatype
mismatch? What is the equivalent data type on the AS/400 for a VARCHAR2
?

Any help will be much appreciated......

Thanks

Ravi
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact [javascript protected email address].