Using SQL Navigator to return a recordset from a procedure

From: John Kramer <john_at_ekramer.net>
Date: 16 Aug 2001 08:42:42 -0700
Message-ID: <fbcef4df.0108160742.662b981e_at_posting.google.com>

[Quoted] 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??? Received on Thu Aug 16 2001 - 17:42:42 CEST