Re: Using SQL Navigator to return a recordset from a procedure

John Kramer wrote:

> I'm having to use SQL Navigator to try to return a recordset from a
> Procedure in Oracle. At another computer, I've used SQL Plus to call a
> Procedure that returns a recordset and have had it return the results
> to the SQL Plus window. Shouldn't I be able to do the same with SQL
> Navigator? I was hoping that I could use the Single SQL Editor to do
> just that, but when I run the procedure, I get an error that says:
> ORA-06550: line 2, column 5: PLS-00306: wrong number or types of
> arguments in call to 'ProcedureName' ORA-06550: line 2, column 5:
> PL/SQL: Statement ignored
>
> I'm using the following in the Single SQL Editor, and then running it.
>
> Begin
> SchemaName.ProcedureName('31', 'A', 'DAY', sysdate);
> End;
>
> I know the types of arguments are not wrong, as I can run the same
> thing in SQL Plus and get results. Any ideas anyone???

I can not imagine why it would work in SQL Navigator.

Daniel A. Morgan Received on Wed Aug 22 2001 - 23:59:37 CEST