Consultor Eletrônico

procedure not found (7678) when using Java Stored Procedure

procedure not found (7678) when using Java Stored Procedure

Title : procedure not found (7678) when using Java Stored Procedure

KnowledgeBase number: 19142
Creation Date: 21/09/99
Modified Date:
This document applies to: SQL92 SDK
Version and Release Number: 9.0B

INTRODUCTION:
============

You might see the error 7678 when you are executing a Java Stored
Procedure from a SQL application.


WHY YOU NEED TO KNOW THIS:
===========================

Java Stored Procedure is an object stored in Progress Database schema.
On SQL point of view, any users who want to access, or execute this
particular object need to have enough privileges on it.

If a SQL client needs to execute the Java Stored Procedure, EXECUTE
privilege is required on this object

If the privilege EXECUTE on the Stored Procedure has not been granted
for the USER who wants to execute the Stored Procedure, the error
7678 may appear.

PROCEDURAL APPROACH:
====================

Possible reason of the error 7678 :

1- The Java Stored Procedure does not exist in the Progress Database
Schema

Suggestion :

- connect with sysprogress user or equivalent from SQL application
to your Database

- check if the Stored Procedure exists on executing the following:

select PROC_TEXT from sysprogress.sysproctext;

- the result should show up all Stored Procedures which can be
called from a SQL Application


2- An EXECUTE privilege has not been granted to the USER for the Java
Stored Procedure.

Suggestion :

- connect with sysprogress user or equivalent from SQL application
to your Database


- GRANT an EXECUTE privilege to the User who needs to execute
the stored procedure on executing the following statement

grant execute on <schema-name>.my_java_proc() to 'SQL_USER';
commit work;

REFERENCES TO WRITTEN DOCUMENTATION:
====================================

SQL-92 Guide and Reference


jmr (21/09/99)