cancel
Showing results for 
Search instead for 
Did you mean: 

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

Former Member
0 Kudos

Hi All,

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

Thanks,

Sindhu.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

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

former_member241146
Active Participant
0 Kudos

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.