Passing Array to Oracle Stored Procedure

I have requirement where in I need to pass a array from Powerbuilder to Oracle
Stored procedure and also I want to know how to access the returned array from
the Oracle stored procedure.
Any help in this regard is appreciated.

Thanks
-Sanjay
---== Posted via the PFCGuide Web Newsreader ==---
http://www.pfcguide.com/_newsgroups/group_list.asp
0
Sanjay
12/4/2001 8:05:39 PM
sybase.powerbuilder.database 9855 articles. 2 followers. Follow

1 Replies
697 Views

Similar Articles

[PageSpeed] 53

Make it a ref in the RPCFUNC declaration. It will be an INOUT argument with
a TABLE OF type in the procedure or function. You will need to pre-fill the
array [to maximum length if it is type string] *before* the call. On return
the values will be whatever the SP set them to. I usually make it a function
which returns the number of elements populated.

Sanjay wrote in message ...
>I have requirement where in I need to pass a array from Powerbuilder to
Oracle
>Stored procedure and also I want to know how to access the returned array
from
>the Oracle stored procedure.
>Any help in this regard is appreciated.
>
>Thanks
>-Sanjay
>---== Posted via the PFCGuide Web Newsreader ==---
>http://www.pfcguide.com/_newsgroups/group_list.asp


0
Jerry
12/4/2001 9:07:11 PM
Reply:

Similar Artilces:

Pass string array to oracle stored procedure.
Hi there, Am trying to pass a string array to an ORACLE 8i stored procedure, I have tested the procedure on the server and know it works, PB7 is giving me any error though when trying to save ; 'variable reference in database statement has unsupported data type' My PB code is; dec{0} ld_sys_ed_key STRING lsa_inp_key[],lsa_inp_val[] //Initialise lsa_inp_key[1] = '1900000137' lsa_inp_key[2] = '1900000139' lsa_inp_val[1] = 'ORCLEVAL' lsa_inp_val[2] = 'YES' ld_sys_ed_key = 0123456789 DECLARE insert_into_system_inputs PROCEDURE FOR ...

Passing array argument to Oracle stored procedure
I have PB 7.0.3 build 10047 and O84 driver running on Windows 2000 with Oracle 8i on a DEC Alpha. Is this the driver we should be using? If not what should we be using and where do I get it? I am getting an error message while passing an array argument to a stored procedure: Select error: ORA-06550: line 1, column 16: PLS-00306: wrong number or types of arguments in call to ...ORA-06550: line 1, column 16: PL/SQL statement ignored. And I do have SQLCA.dbparm ="pbdbms=0" It works fine if I pass a value that is not an array. Here is my pl/sql program: CREATE OR ...

ora_type and passing array to an oracle stored procedure
------_=_NextPart_001_01C1897F.15FAE2A0 Content-Type: text/plain Hello, I have two questions, one which I think is probably simple. 1. (the simple one). Is there a list of all the ora_type codes somewhere (e.g. ORA_CLOB, 24) 2. How do I pass an array from perl to a PL/SQL stored procedure using DBI? I have the following types in my database: SQL> desc id_rec Name Null? Type ----------------------------------------- -------- ------------------------ ---- ID NUMBER SQL> des...

Is it possible to pass an array to a stored procedure -oracle
Hi, I am new to stored procedure based datawindows. Pb 6.5,Oracle 7.3.3. Could anybody clarify me that can we the pass the data in a DW to a oracle stored procedure as a input param in the form of an array or PL/SQL tables or some other means? Thanx mega Support for PL/SQL table arguments is limited to RPC calls with arrays of atomic data types. Arrays of records are not supported. meghavathy <mathi_a@hotmail.com> wrote in message news:8#5esslb$GA.184@forums.sybase.com... > Hi, > I am new to stored procedure based datawindows. > Pb 6.5,Oracle 7.3.3. >...

(Fwd) Pass Arrays to Stored Procedures in Oracle
----- Forwarded message from "Grimes, Greg" <ggrimes@ercot.com> ----- Delivered-To: tim.bunce@pobox.com Subject: Pass Arrays to Stored Procedures in Oracle Date: Wed, 13 Aug 2003 14:28:38 -0500 From: "Grimes, Greg" <ggrimes@ercot.com> To: <Tim.Bunce@pobox.com>, "Steve Baldwin" <stbaldwin@multiservice.com> X-OriginalArrivalTime: 13 Aug 2003 19:28:38.0385 (UTC) FILETIME=[1883B610:01C361D1] Steve, I saw your posting concerning pipelined functions. How does the perl script benefit from this approach? I would assume the perl scri...

pass array to store procedure in dbi oracle
------_=_NextPart_001_01C2C838.DC51E8C5 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi is it posible to send an array to a store procedure in dbi ( oracle ) ? thanks =20 =20 Ran Aker R&D Programmer tel: 972.9.892.1052 =20 DealTime=AE<?xml:namespace prefix =3D o /> Compare products, prices, and=20 stores at www.dealtime.com <http://www.dealtime.com/>=20 =20 ------_=_NextPart_001_01C2C838.DC51E8C5-- ...

Passing Arrays to Oracle 7.3 stored procedures as argument
From datawindow it's possible to pass array argument to SQL statement. Is it possible to pass array as argument to Oracle 7.3 stored procedure ? The easiest is proably passing a string that is not comma-delimited and then parse it out in your sp. -- Terry Dykstra (TeamSybase) Canadian Forest Oil Ltd. Sybase Developer's Network: http://www.sybase.com/sdn "Evgeny" <evgeny@cool.mb.ca> wrote in message news:3925305c.173883938@forums.sybase.com... > From datawindow it's possible to pass array argument to SQL statement. > Is it possible to pass a...

How can I pass a bi-dimensional array to an oracle stored procedure ?
Suppose that I have the following vb.net bi-dimensional array: Dim ds As DataSet = SomeDataSet() Dim num_cols As Integer num_cols = ds.Tables(0).Columns.Count - 1 Dim num_rows As Integer num_rows = ds.Tables(0).Rows.Count - 1 Dim zmatrix(num_rows, num_cols) As StringDim row As Integer = 0 For Each rw As DataRow In ds.Tables(0).Rows Dim col As IntegerFor col = 0 To num_cols - 1 zmatrix(row, col) = "" NextFor col = 0 To num_cols - 1 If Not IsDBNull(rw(col)) Then zmatrix(row, col) = rw(col).ToString() End If Next row = row + 1 NextHow can I pass that bi-dim...

Session Array and pass array in stored procedure
hi all 1. it is possible to use session array. 2. i want to store group of values in session.  3. finally i want pass this session in stored procedure. give me some source 1. it is possible to use session array. , yes you can create an array of sessions if you want 2. i want to store group of values in session. yes you can store collections,objects .....UDT 3. finally i want pass this session in stored procedure. give me some source....dont think you can do this, it kind of goes against best practices....usually your sql box should NOT be on your web server for performance a...

Passing array parm to Oracle stored procedure
begin 644 sample.sql M0U)%051%($]2(%)%4$Q!0T4@4$%#2T%'12!P:V=?<&QS<6Q?=&%B;&5?=&5S M=`T*25,-"B`@5%E012!E;7!?:61?=&)L($E3(%1!0DQ%($]&($Y534)%4B!) M3D1%6"!"62!"24Y!4EE?24Y414=%4CL-"B`@5%E012!M>5]R97-U;'1?<V5T M($E3(%)%1B!#55)33U([#0H@(%!23T-%1%5212!S<%]P;'-Q;%]T86)L95]T M97-T*&%R9U]E;7!?:60@24X@96UP7VED7W1B;"P@(&%R9U]E;7!?;F%M92!) M3B!/550@;7E?<F5S=6QT7W-E="D[#0I%3D0@<&MG7W!L<W%L7W1A8FQE7W1E M<W0[#0HO#0I#4D5!5$4@3U(@4D503$%#12!004-+04=%($)/1%D@<&MG7W!L M<W%L7W1A8FQE7W1E...

Passing array parm to Oracle stored procedure
I have PB 7.0.3 build 10047 and O84 driver running on Windows 2000 with Oracle 8i on a DEC Alpha. Is this the driver we should be using? If not what should we be using and where do I get it? I am getting an error message while passing an array parameter to a stored procedure: Select error: ORA-06550: line 1, column 16: PLS-00306: wrong number or types of arguments in call to ...ORA-06550: line 1, column 16: PL/SQL statement ignored. And I do have SQLCA.dbparm ="pbdbms=0" It works fine if I pass a value that is not an array. Thanks. I, for one, can't read atta...

Passing arrays to stored procedures
Dear all, i want to know how i can pass multiple values in the form of arrays to a stored procedures. the technique by which i pass multiple values to a stored procedure beginning along with declarations are as follows: Dim configurationAppSettings As System.Configuration.AppSettingsReader = New System.Configuration.AppSettingsReader() Me.cmdInsSlabHmst = New System.Data.OleDb.OleDbCommand() Me.OleDbConnection1 = New System.Data.OleDb.OleDbConnection() Me.cmdInsSlabDMst = New System.Data.OleDb.OleDbCommand() ' 'cmdInsSlabHms...

Passing array to Oracle Procedure
Hi, PB7.0.2 8046 and Oracle 8i 8.1.(5&6&7) I have a table of 10,000 records. The enduser selects about 3000 records (e.g. by filtering). Now I want to pass the selection to an Oracle Procedure. Is this possible ? What's the correct syntax for the Oracle Procedure ? Is it also possible to pass structures/nvo's ... ? Can someone give me an example ? Many Thanks in advance, Wim Teuwens This is a multi-part message in MIME format. --------------25E3D63F6D4D57E011A3717E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Hi Wim, ...

Passing an Array to a Stored Procedures
How to do this ? ============================== CREATE procedure dbo.AddTb2FromTb1 @Tb1No nvarchar(1000) as insert into Tb2 (*) select * from Tb1 where Tb1 IN (@Tb1No) /* How to Passing an Array to a Stored Procedures ??? */ ============================== dbo.AddTb2FromTb1 'No001' is Work ! dbo.AddTb2FromTb1 'No001,No002,Bo003' is not Work ! If you are using SQL 2000 you can create a user-defined fnction - have a look at the following link: Sql Team I Try CnvToChar() is work... select * from CsvToChar('PO001234,PO123') is work CharValue ---...

Web resources about - Passing Array to Oracle Stored Procedure - sybase.powerbuilder.database

Parliamentary procedure - Wikipedia, the free encyclopedia
... of the House of Commons of the Parliament of the United Kingdom , from which it derives its name. In the United States, parliamentary procedure ...

Procedure is more a snap than a snip
A QUEENSLAND doctor is bidding to set an unusual world record by performing the highest number of vasectomies in one day, with the help of fellow ...

Will Paul Ryan Make His Mark As Speaker By Instituting Impeachment Procedures Against President Obama ...
Wisconsin Ayn Rand devotee Paul Ryan just started his new job as Speaker of the dysfunctional House Republicans. And he's already headed for ...

NFL security procedures in question after rappelling protesters
Two protesters with sophisticated gear disrupted the Panthers-Colts game in Charlotte Monday night, bringing into question security at the stadium ...

'Painless' dental cavity procedure regrows tooth enamel
... "cavity" a lot of people sweat thinking about painful injections and relentless drilling. But scientists in Britain have developed a new procedure ...

Kim Zolciak Shares Glam Post-Heart Surgery Selfie, Calls Procedure 'a Success'
Kim Zolciak Shares Glam Post-Heart Surgery Selfie, Calls Procedure 'a Success'

Wall Street Regulator (FINRA): Procedures, Recordkeeping, Education Key For Compliant Social Media
Meeting regulatory requirements when using social media requires proper procedures, recordkeeping solutions, sufficient resources to monitor ...

US AIRPORT SECURITY CONCERNS DHS to heighten procedures in light of Russian jet bombing theory, poor ...
US AIRPORT SECURITY CONCERNS DHS to heighten procedures in light of Russian jet bombing theory, poor test performances by TSA screeners

Concession: Ryan promises Freedom Caucus he’ll delay discussion of reforming procedure for removing the ...
Compromise. Like I said this morning, it sounds like they did a little horse-trading at their summit. Ryan wants them to give up their right ...

Penis Enlargement Procedure Kills Man, Botched Procedure Lands Woman In Prison
... a 38-year-old bartender with no medical training at all who told him she could medically enhance the size of his penis at home. But the procedure ...

Resources last updated: 12/4/2015 4:22:53 AM