Stored Procedure!! SQL0444n

[Loop11]

Hello,

i wrote a stored procedure, which ends with the command:
DB20000I The SQL command completed successfully.
But when i call the stored procedure i got the following error:
SQL0444N Routine "DB" (specific name "DB") is implemented
with code in library or path "\test", function "DB" which cannot be accessed. Reason code: "4". SQLSTATE=42724

Can anybody help me....? I knwo what reason code 4 is, but i can't find the error!!

THX

 

[Mercury2]

From SQL Messages and Codes manual:

"The external program or service program associated with
the procedure or function cannot be found. Ensure that
the an object exists with the name specified on the
DECLARE PROCEDURE, CREATE PROCEDURE, or CREATE FUNCTION statement. If no name was specified, ensure that an object with a name which matches the procedure name specified exists. If a program name was specified, a program object must exist. If an entry point name was specified, then a service program object must exist. Try the request again.

 

[Loop11]

Mmmhhh, i don't knoe exactly..my procedure look like this:

Create PROCEDURE names(IN dbname CHAR(8))
SPECIFIC names
DYNAMIC RESULT SETS 1
DETERMINISTIC
LANGUAGE C
PARAMETER STYLE GENERAL
NO DBINFO
FENCED
THREADSAFE
READS SQL DATA
PROGRAM TYPE SUB
EXTERNAL NAME 'testt!names'
;

and it says complete successfully......something wrong here?

Thx