What is the name of your stored procedure class?  Please show us the syntax
by which you registered the stored procedure.  What release of OS/400 are
you on?  Using WRKLNK or Operations Navigator, do you see
/QIBM/UserData/OS400/SQLLib/Function/JAVASTOREDPROCS.JAVASTOREDPRO?  If so,
what are the authorities?

Gary 

> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of cornelius, chad
> Sent: Tuesday, September 14, 2004 12:55 PM
> To: 'JAVA400-L@xxxxxxxxxxxx'
> Subject: Java Stored Procedures on ISeries
> 
> I have created a test stored procedure that should return a 
> result set using SQLJ.  I have compiled, built a jar file, 
> registered the stored procedure in the order that IBM's red 
> books suggest.  When I try to execute the procedure, I 
> continually get a "Not authorized to object 
> JAVASTOREDPROCS.JAVASTOREDPRO in 
> /QIBM/UserData/OS400/SQLLib/Function type *N."  Does anyone 
> know what I am doing wrong or what is causing this error?
> The system admin. has given me full authority to library 
> /QIBM/UserData/OS400/SQLLIB/Functions.
> 
>  
> 
> Thanks,
> 
> Chad
> 
>  
> 
> --
> This is the Java Programming on and around the iSeries / 
> AS400 (JAVA400-L) mailing list To post a message email: 
> JAVA400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change 
> list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx Before posting, 
> please take a moment to review the archives at 
> http://archive.midrange.com/java400-l.
> 


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2022 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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.