Executing Stored Procedure

[Former Member]

Hi all,

I have to execute a stored procedure through the Native SQL String format.

I have converted my data a string and trying to execute the procedure using the string format as

"EXCEUTE TESTXIPROCEDURE ('Aditya',786,'SE','1/25/2007');"

I also tried without the EXECUTE

but it give the following error

"invalid SQL statement ' executing service raw2sql with SQL statement 'TESTXIPROCEDURE ('Aditya',78807,'SE','1/8/2006');'"

Is this not the way to ivoke the procedure

Please guide me through this

Rgds

Aditya

[Former Member]

Thnks

Rgds

Aditya

[Former Member]

hey

have a look at the following

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Thanx

Ahmad

[Former Member]

oops,didnt see ur using Native string,sorry about that

anyways have a look at the following

thanx

Ahmad