You will have to write an anonymous block that declares the array
variable, and passes that array to your procedure under test.
- "Basavaraja, Ravindra" <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> I want to test a procedure that accepts an array as input.I want to
> test
> this script from
> SQL*PLUS.How can I pass array value from sql*plus
>
> Procedure testproc(iarrPID IN PID_VArray).
>
> I want to test it this way
>
> SQL>Exec testproc(?????)
>
> Tried this was
> SQL>EXEC testproc(33);
>
> ERROR at line 1:
> ORA-06550: line 1, column 7:
> PLS-00306: wrong number or types of arguments in call to
> 'testproc'
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> Pls help
>
> Thanks
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Basavaraja, Ravindra
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Jun 17 2003 - 18:00:32 CDT