cancel
Showing results for 
Search instead for 
Did you mean: 

inserting constant into stored procedure

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

dharamveer_gaur2
Active Contributor
0 Kudos

Hi

Can u right stored procedure code.

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

Former Member
0 Kudos

Hi Gaur,

can you give me clear idea

Thanx

Sampath

Answers (2)

Answers (2)

dharamveer_gaur2
Active Contributor
0 Kudos

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.

dharamveer_gaur2
Active Contributor
0 Kudos

Can Post Your stored procedure code?

Former Member
0 Kudos

Hi Gaur,

Stored procedure

Declare

dcode number;

sol varchar2;

begin

delete(dcode,sol);

end;

thanx

sampath