on 11-16-2010 1:06 PM
Hi All,
Please tell me how to create a datatype for a storeprocedure which has got an array structure ?
Thanks,
Sindhu.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.