regarding stored proceduree call

[Former Member]

Hi

i refered the blog given by Siva Maranani,for beginners to understand about stored procedure its is helpful.

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

well i have a query that he did not mention where to write this SPC (Stored Procedures).

i am using ms access as my db.

can any body guide me where to write S P (code).

step to step.

regards

sandeep.

[Former Member]

Hi

check this blog

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

regards

krishna

[Former Member]

Hi

can u suggest any thing regarding stored procedure.

[former_member529475]

HI Sandep

Create the Datatype. In that instead of writing query in "Query SQL Statement" parameter you have to write name of stored proc

In sender JDBC adapter you have to specify an SQL EXECUTE statement to execute a stored procedure, which contains exactly one SELECT statement.

Give your procedure name after SQL EXECUTE and then create datatype according to the output of yourprocedure

Cheers..

Vasu

<i>** Reward Points if found useful **</i>

[justin_santhanam]

Sandeep,

Refer the below link .

http://support.microsoft.com/?kbid=202116

Best regards,

raj.