Re: How to call a ORACLE stored procedure which parameters are PL/SQL table and %ROWTYPE

Sounds as if you need to:

    Put the procedure in a package
    Declare the table type in the package so it can be seen     In the anonymous block, declare a variable of the packaged table table

Not sure what problem is with the Pro*C, but it is probably based on the same visibility issue.
--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

ellen111_at_my-deja.com wrote in message <7ilevo$1f0$1_at_nnrp1.deja.com>...
>I compiled a stored procedure in ORACLE DATABASE. which has two
>OUT parameter, one is PL/SQL table, and another is table%ROWTYPE.
>when I call it by PL/SQL block, the %ROWTYPE is OK, but the error
>message said the PL/SQL table is wrong match data type( I declared
>a same PL/SQL table in the PL/SQL block). and also, I want to
>call this procedure in a proc* program, but when I compile the .pc
>program, the error is : the procedure name must be declared.
>do you know how to declare a procedure in a proc file? I execute it
>using embed PL/SQL block in the proc file.
Received on Fri May 28 1999 - 02:54:53 CDT