Whenever you are getting the error for trying to access particular function via stored procedure, and you get the error, most probably the CurrentFunctionPath does not include the valid (or contains not enough) schema names.
The CurrentFunctionPath is a property, and can contain one or more schema names, separated by commas and enclosed in double quotation marks. Also, the order of the defined schemas determines the orders in which the function and procedure names are resolved.
The default value is the default CURRENT PATH (or CURRENT_PATH) special register setting at the database server.
Blog about middleware/ weblogic/ websphere hidden gems, problems and solutions, security issues and hacks
Most Popular Posts
-
TL;DR Servlet - html in java JSP - java in html Details: JSP (Java Server Pages) are pages that contain Java code tha...
-
How to disable remote shutdown in Tomcat Examples: change the port number from default to different one (not recommended) chang...
04/07/2016
CurrentFunctionPath - resolving function and stored procedure references
Labels:
current_path,
currentfunctionpath,
db,
db2,
functionpath,
java,
jvm,
procedure,
schema,
storedprocedure,
was,
websphere
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment