[sqr-users] oracle stored procedure

["Ben Anderson" <pegandersonbd1@hotmail.com>]

Hi all,
I know this has been asked in the past, but I can't get anything to work.  
I've seen a bunch of different ways to call stored procedures from SQR.  Is 
there any one best way?

We're using:
  SQR V6.1.3
  Oracle 8, soon to be 9i

This is the closest I've come, because at least SQR knows when I don't have 
the right number of parameters....
----------------------------------------------------------------------------------------------------------------------------------------
  begin-sql
     begin
        mySchema.myPackage.myOneArgFunction();;
     end;;
  end-sql

gives this output:

(SQR 5528) ORACLE OPARSE error -6550 in cursor 1:
   ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'MYONEARGFUNCTION'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
SQL:  begin mySchema.myPackage.myOneArgFunction(); end;
Error at:  mySchema.myPackage.myOneArgFunction();
----------------------------------------------------------------------------------------------------------------------------------
whereas this:

  begin-sql
     begin
        mySchema.myPackage.myOneArgFunction($myParam);;
     end;;
  end-sql

yields this output:

(SQR 5528) ORACLE OPARSE error -6550 in cursor 1:
   ORA-06550: line 1, column 7:
PLS-00221: 'MYONEARGFUNCTION' is not a procedure or is undefined
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
SQL:  begin mySchema.myPackage.myOneArgFunction($myParam); end;
Error at:  mySchema.myPackage.myOneArgFunction($myParam);
-------------------------------------------------------------------------------------------------------------------------------------

Any ideas?
Thanks,
Ben Anderson

_________________________________________________________________
Concerned that messages may bounce because your Hotmail account has exceeded 
its 2MB storage limit? Get Hotmail Extra Storage!         
http://join.msn.com/?PAGE=features/es

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users