Current Position:Home > How to Create a datatype for a storeprocedure which has got array ?

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

Update:10-11Source: network consolidation
Advertisement
Hi All,
Please tell me how to create a datatype for a storeprocedure which has got an array structure ?
Thanks,
Sindhu.

The Best Answer

Advertisement
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.
  • How to Create a datatype for a storeprocedure which has got array ? Update:10-11

    Hi All, Please tell me how to create a datatype for a storeprocedure which has got an array structure ? Thanks, Sindhu.Hi Sindhu. You would have to use a JDBC Cursor for this but it's possible only Output parameters, not Input parameters. It's descri

  • Creating own datatypes/handles Update:11-30

    Hello! I have a C library which has differents functions that expect various handles (uint32) as parameters. Calling these functions from within LabVIEW is not a problem. What I want to do is make these handles avaible to the outside, accessible thro

  • Problem with creating a datatype Update:11-30

    Hi, Scenario : JMS to IDOC I need to create a datatype like this, Element : StringA Attribute : C83 value where C106 = "PICKUP" Element : StringA Attribute : C83 value where C106 = "DROPOFF" Please help me on how can i create like this

  • I want to create a "clean" sawtooth wave with my own inserted array. Update:11-30

    I have a PXI module with a fgen5411. I can make a arbitrary waveform with my own array. that's not the problem. The real problem is that if I insert a waveform array with 4096 steps, Labview divides the steps and the 4096 steps are no longer 4096 ste

  • How can I create a custom data type that is a 2D array of string by using TestStand API? Update:11-30

    Hi all, I'm new in TestStand: I'm able to create a custom data type that is a 1D array of string but I cannot find the way to create a 2D array of string. Can anyone help me? Thank you in advance. FedericoI made it!! Indeed my 2D array is an item of

  • Create clob datatype in a column Update:10-11

    Hi, I am working in oracle9i and solaris 5.8. I want to create a table with a cloumn contains clob Datatype.. Please explain me how to create a clob datatype in a column and how to assign this and how to insert datas into the datatype... Regs..Hey, R

  • Creating Complex Datatypes in Application Module Service Interface Update:11-30

    HI All, I need to create the complex datatype as response in Application module service interface(Custom method). Is there any way to create it. I am able to create when i have simple datatype as response, Whereas the complex type is not able to crea

  • Creating Abstract datatypes from Create Type As Object Update:11-30

    hi. I am define new type abstract datatypes as create type cust_address_ty as object (STREET VARCHAR2(25), CITY VARCHAR2(25), COUNTRY VARCHAR2(25)); then insert data into new created table when we run sql select command for * from following error occ

  • Creating primitive datatypes... Update:11-30

    hi, This may be a question that should have come a long time back but still i would like to know to create a class that can accept values just like primitive data types...like String str="Hello"; I would like to create a class which can directly

  • Create tree and store it's value in an array Update:11-30

    I have to create a tree as shown below: 2--->7-->6-->5-->3 ---->4 ---->8 Here the numbers are the nodes of the tree and --->denotes the connection between them. 2 7 8 6 5 4 3 Another representation 2 is connected to 7and 8, 7 is conne