Skip to Content
avatar image
Former Member

How to Create a datatype for a storeprocedure which has got array ?

Hi All,

Please tell me how to create a datatype for a storeprocedure which has got an array structure ?

Thanks,

Sindhu.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 16, 2010 at 01:42 PM

    Hi Sindhu.

    You would have to use a JDBC Cursor for this but it's possible only Output parameters, not Input parameters.

    It's describle in a help link:

    Defining an EXECUTE Statement http://help.sap.com/saphelp_nwpi711/helpdata/en/44/7b72b2fde93673e10000000a114a6b/frameset.htm

    The following SQL data types are supported:

    INTEGER, BIT, TINYINT, SMALLINT, BIGINT, FLOAT, REAL, DOUBLE, NUMERIC, DECIMAL, CHAR, VARCHAR, STRING, LONGVARCHAR, DATE, TIME, TIMESTAMP, BINARY, VARBINARY, LONGVARBINARY, BLOB (input and output), CLOB (input and output), CURSOR (output; only in connection with the Oracle JDBC driver)

    I think you can execute your StoreProcedure many times depends of array occurs.

    Regards.

    Bruno.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 16, 2010 at 05:00 PM

    Follow below structure:-

    Statement - Root Node- 0-Unbounded

    --- SQL Stored Procedure child node - 0-1

    --- Action - Attribute

    ---Element 1 --0-1

    -


    isInput - attribute

    -


    type - attribute

    SQL Stored procedure is child of statement nod

    and Action

    Element 1 are at same level which is child of SQL Stored procedure node.

    chirag

    Edited by: Chirag Gohil on Nov 16, 2010 10:31 PM

    Add comment
    10|10000 characters needed characters exceeded