can I connect to Sybase using UDF and call stored procedure

[Former Member]

My requirement is

I have two fields in under a root node, root can occue 0..unbounded.

<root>

<username>

<request>

</root>

I need to pass these as parameters to External Stored procedure which is in Sybase.

Can I do it using UDF? Please give some example

[Former Member · Accepted solution]

somebody pls give more inputs

[Former Member · Accepted solution]

Hi..

You can create JDBC lookups and you can execute stored procedure from there.

Refer useful documents.

/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

Thanks

Gaurav

[Former Member]

try

you can call the receiver adapter which will do

try using PrepareCall instead of Statment/PreparedStatement..