Hi,

I am trying to pass parameters to a stored procedure using the JDBC
driver. I am connecting to MS SQL 2008 in Windows platform.

I am using the below script to execute the stored procedure.

The "$AGENT-JDBC-CALL" contains the parameters that needs to be sent to
the stored procedure.

XPath("command:execute($destCommandProcessor,$AGEN T-JDBC-CALL)")

I did include the policy namespace definition. i had included the
"command" as prefix and
"com.novell.nds.dirxml.driver.XdsCommandProces sor" as the URI.

however i am getting the below error:

DirXML Log Event -------------------
Driver: \Mytree\Myorg\Drivers\DriverSet\JDBCDriver
Channel: Subscriber
Status: Error
Message: Code(-9131) Error in
vnd.nds.stream://Mytree/Myorg/Drivers/DriverSet/JDBCDriver/Subscriber/Invoke+Stored+Procedure#XmlData:127
: Error evaluating XPATH expression
'token-xpath("command:execute($destCommandProcessor,$AGEN T-JDBC-CALL)")'
: com.novell.xml.xpath.XPathEvaluationException: function
'command:execute' not found.
[09/23/10 00:02:08.305]:C:\NIM Logs\SentinelInvestments ST:
DirXML Log Event -------------------
Driver: \Mytree\Myorg\Drivers\DriverSet\JDBCDriver
Channel: Subscriber
Status: Error
Message: Code(-9083) Error submitting event to subscriber:
Code(-9131) Error in
vnd.nds.stream://Mytree/Myorg/Drivers/DriverSet/JDBCDriver/Subscriber/Invoke+Stored+Procedure#XmlData:127
: Error evaluating XPATH expression
'token-xpath("command:execute($destCommandProcessor,$AGEN T-JDBC-CALL)")'
: com.novell.xml.xpath.XPathEvaluationException: function
'command:execute' not found.


Product Version:

Windows IDM 3.6.1, Windows MS SQL 2008, Windows eDir 8.8 SP5

Thanks,
mvrk


--
mvrk
------------------------------------------------------------------------
mvrk's Profile: http://forums.novell.com/member.php?userid=32023
View this thread: http://forums.novell.com/showthread.php?t=421570