on 11-26-2008 9:59 AM
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
Hi
Can u right stored procedure code.
You can Pass 2 In type Parameter in your stored procedure to execute query.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
First Execute your Stored procedure from SQL editor. Is It performing functionality?
Add 2 Field Isinput in your target structure and Map with Constant("TRUE") and in Type field Pass the Value for Stored procedure.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can Post Your stored procedure code?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.