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 REPLACE PACKAGE pkg_plsql_table_test
IS
  TYPE emp_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
  TYPE my_result_set IS REF CURSOR;
  PROCEDURE sp_plsql_table_test(arg_emp_id IN emp_id_tbl, arg_emp_name
IN OUT my_result_set);
END pkg_plsql_table_test;
/
CREATE OR REPLACE PACKAGE BODY pkg_plsql_table_test
IS
  PROCEDURE sp_plsql_table_test(arg_emp_id IN emp_id_tbl,
   arg_emp_name IN OUT my_result_set)
   IS
  BEGIN
     OPEN arg_emp_name FOR
       SELECT RTRIM(ENAME) INTO arg_emp_name
       FROM emp
       where empno = arg_emp_id(1);
       --where empno in(arg_emp_id(1),arg_emp_id(2), arg_emp_id(3));
  END sp_plsql_table_test;
END pkg_plsql_table_test;
/

Thanks.


0
NOSPAM__arayhrer
11/6/2001 4:58:38 PM
sybase.powerbuilder.datawindow 28057 articles. 4 followers. Follow

0 Replies
978 Views

Similar Articles

[PageSpeed] 30

Reply:

Similar Artilces:

all arguments passed as string in stored procedure datawindow with Oracle?
Can someone please explain me this? I'm using PB8.0.3 build 9704 with Oracle 9.2. There is a datawindow based on a stored procedure with the following execute statement and retrieval arguments: procedure="1 execute proc1;0 p_kdnr = :an_kdnr, p_zeit = :adt_date, p_kond = 0, p_lg = 'N', p_atyp = :as_typ" arguments=(("as_typ", string), ("an_kdnr", number), ("adt_date", datetime), ("ac_wfak", number), ("as_wakz", string), ("as_name", string)) The stored procedure in Oracle looks like this: CREATE...

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...

Passing arrays as arguments to Stored Procedures
------_=_NextPart_001_01C2E7C4.FBB4EDA0 Content-Type: text/plain; charset="ISO-8859-1" Hi, I am using PERL version 5.6. One of the applications developed needs data in arrays to be passed as arguments to stored procedure in Oracle 8i. I'm calling stored procedure inside the PERL program using DBI and DBD::Oracle. But I am unable to bind arrays as parameter to the stored proc. Using bind_param gave the following error: Can't bind a reference (ARRAY(0xc8e260)) Using bind_param_array gave the following error: Can't locate object ...

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 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 wil...

Passing Array argument to SQL Stored Procedure
Can anybody advise on how to pass a list of values (String array) as an argument to a MS SQL stored procedure. TIA HK Sorry that I do not have an answer but please tell me Which version of MS SQL supports arrays? If it does not support arrays internally, I am afraid you will have to -pass through some sort of pseudo temporary table and give the stored proc a hand to those rows - or If you know the maximum number of items is only a few ( 4 or 5), you could kludge by using extra variables instead of arrays. Good luck "HK" <hirdesh.kumar@wcom.com> wrote in message news:Tw$ROT1pAHA.258@forums.sybase.com... > Can anybody advise on how to pass a list of values (String array) as an > argument to a MS SQL stored procedure. > > TIA > HK > > ...

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. >...

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 ...

(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-- ...

Oracle DBI/DBD stored procedure array arguments
Hi, I was wondering if there was a way to pass data to or from a stored procedure argument, where the data type of the parameter is an array (TABLE OF NUMBER, for example). The problem I'm having is in binding the data to the arguments. For example: Stored procedure: pkg.foo() : -~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~ TYPE NUMBER_TAB is TABLE of NUMBER index by BINARY_INTEGER; PROCEDURE foo ( i_arg IN NUMBER_TAB, o_arg OUT NUMBER_TAB ) IS begin [...] end; -~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~ Perl: ...

PowerBuilder 8 and Oracle 8 Stored Procedure Datawindow
I worked many years with Sql Server and it was easy to do, but I don't know how to do in Oracle: How a Oracle 8 Stored Procedure can return to PowerBuilder 8 the result of a query or a recordset (in Sql Server is as easy as put a select sentence at the end of the procedure). I don't want to use temporary tables for a concurrence issue. Can anyone give me a help? Thanks in advance, Ra�l La Torre You need a REF CURSOR. See enclosed datawindow examples. -- Terry Dykstra (TeamSybase) http://powerbuilder.codeXchange.sybase.com/ http://www.pb9books.com product ...

Passing multiple rows from a datawindow into an oracle stored procedure
We are using PB 9.0.2 and Oracle 10g. I am wondering if PB supports passing collections into stored procedures i.e. a list of data window rows that map directly into an associative array definition as an input parameter into a stored procedure (or a UDT collection or something similar). If not is there a way to do this without creating separate arrays for each paramater being passed into the stored procedure (i.e. a known work around for .Net prior to Oracle releasing ODP 11g). Any help/insight is appreciated. I've been going through 'Powerbuilder 9 - Advanced Client ...

Oracle DBI/DBD stored procedure array arguments #2
Thanks for your help, I was wondering how the arguments get binded (how do I associate the data to the arguments?) For example, let's say we want to pass an array to the stored procedure: my @arg1 = (1,2,3,4,5); and want to return the result in another variable? Would I use bind_param_inout() somehow? $sth->bind_param_inout(??? not sure what would go here ???); my $sth = $dbh->prepare("{Call PKG.foo(?,{resultset 1000, o_arg})}"); Thanks again! Dan -----Original Message----- From: Arul, Rex [mailto:rarul@newenergyassoc.com] Sent: Wednesday...

Crash on retrieval of datawindow with null arguments passed for stored procedure
front end: pb 9.0.1 backend : sybase ase 12.5.1 error: crashing with pb90.exe when null argument is passed as one of the arguments in the script for retrival from datawindow using stored procedure as the source the application crashes whereas the same procedure works fine with null arguments passed when executed directly from backend. ...

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
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 NULLs to Oracle 7.3.2.1 Stored Procedure From DataWindow
I am creating a DataWindow from an Oracle Stored Procedure. When I pass a NULL argument of type NUMBER, the driver converts it into a STRING with the value "NULL" thus I get the error "invalid cursor" because I giving a NUMBER argument a STRING value. It also converts a NULL argument of type DATE into Jan-5-1995 (huh). If anyone have came across this bug and have any solutions for it, I would really appreciate a response. I am using 32 bit PB5.0.03 on Windows NT. Thanks in advance. Jameel Stephen Abdo Programmer, MCI Systemhouse jabdo@shl.com Will the ...

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 arguments to a stored procedure.
A stored procedure can the data source for a datawindow. How can I pass arguments to a Stored procedure which is a data source for a datawindow??? GS; Just issue a retrieve passing appropriate values... dw_1.Retrieve(arg1,arg2,arg3,...) HTH, Austin "GS" <gulpreet.sandhu@ftb.ca.gov> wrote in message news:eQDx2fiHDHA.284@forums-1-dub... > A stored procedure can the data source for a datawindow. How can I pass > arguments to a Stored procedure which is a data source for a datawindow??? > > > > ...

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 ---...

Passing arguments to stored procedures
Firs of all, the relevant InfoMaker/DB info: InfoMaker 7.0.3 Bulid 10009, connecting to Sybase ASE 12.0 with the native drivers. Now the real question. How do I create a report that allows me to pass arguments to a stored procedure? I've been testing a grid report with the sp_help stored procedure, but all it ever does is return the list of views and tables. I want it to return the information on a single table, so I need to pass the table name. Unfortunatly, nothing I've tried works. I'd like to think that I could set it up to prompt me for an argument, b...

How to pass an array to a stored procedure?
Hi, I have input parameters in my PB app,, which are the arrays: bank#, item_id, etc. How to pass them to my stored procedure stored in MS SQL Server6.5 db? The stored procedure is used as a data source for a datawindow. Thanks, Henry Create a temp table using Dynamic SQL Format 1 and populate the table with the values you want. Now in the called stored procedure select from the temp table. ie use a cursor or something along the lines of that. If you are just using the values in a single select you can do a where col in (select col_you_need from #temp_table). This shoul...

Web resources about - Passing array argument to Oracle stored procedure - sybase.powerbuilder.datawindow

Invasiveness of surgical procedures - Wikipedia, the free encyclopedia
There are three main categories which describe the invasiveness of surgical procedures . These are: non-invasive procedures , minimally invasive ...

Eye tattoos: Tattooist Luna Cobra defends practice following calls to ban procedure
IT SOUNDS like the really gross scene in a horror movie.

Survivors of female genital mutilation outraged by 'compromise' which could legalise procedure
Survivors of female genital mutilation are fighting back against a so-called compromise, which could let a modified form of the procedure continue. ...

Doctors Perform Medical Procedure On Wrong Newborn
The procedure was meant for another child.

Old Lady Lawyer: Uncivil Procedure
What is some of the worst behavior you've witnesses by attorneys?

Butt procedures, male breast reduction growing slices of plastic surgery
Every 30 min of 2015, a rump was remodeled. Men had 40% of all breast reductions.

"Gynecologists Kavita Shah Arora and Allan Jacobs said procedures that slightly changed the look of a ...
"... were comparable to male circumcision or cosmetic procedures in Western countries like labiaplasty. Laws against mild modifications were ...

We need to reform the culture of law enforcement, not just the procedures
We need to reform the culture of law enforcement, not just the procedures by digby I have a new piece up at Salon this morning about police ...

Rescued tiger cub "Himmel" dies during medical procedure - CBS News 8 - San Diego, CA News Station ...
Alpine animal rescue sanctuary Lions, Tigers & Bears is sadly reporting Himmel, the tiger cub found roaming the streets of Hemet and rescued ...

Catholic hospital allowed to deny sterilization procedure, judge says
Hospital in California argued that the procedure known as ​tubal ligation would violate its religious freedom

Resources last updated: 3/7/2016 9:53:53 PM