Skip to Content
avatar image
Former Member

inserting constant into stored procedure

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Nov 26, 2008 at 10:35 AM

    Hi

    Can u right stored procedure code.

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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 26, 2008 at 10:53 AM

    Can Post Your stored procedure code?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Gaur,

      Stored procedure

      Declare

      dcode number;

      sol varchar2;

      begin

      delete(dcode,sol);

      end;

      thanx

      sampath

  • Nov 26, 2008 at 11:16 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded