inserting constant into stored procedure

[Former Member]

Hi Experts,

There is a requirement were a stored procedure is called to truncate the tables in the database

this stored procedure takes input as two values truncate(exitcode,msg).

can the two variables can be mapped to constant is it possible.

<action>execute</action>

<table>truncate</table>

<exitcode> constant</exitcode>

<type>constant(numeric)</type>

<msg>constant</msg>

<type>constant(varchar)</type>

kindly respond

Thanx&Regards

Sampath

[dharamveer_gaur2 · Accepted solution]

Hi

Can u right stored procedure code.

You can Pass 2 In type Parameter in your stored procedure to execute query.

[Former Member · Accepted solution]

Hi Gaur,

can you give me clear idea

Thanx

Sampath