Re: [sqr-users] oracle stored procedure

["George Jansen" <GJANSEN@aflcio.org>]

Every PL/SQL subprogram has a "signature": for procedures this is the
type and number of the arguments,for functions it includes also the
return value. If a function is defined as 

FUNCTION onearg (p_one IN NUMBER) RETURN NUMBER ....

then

BEGIN
     onearg(5);
END;
/

will  give you the error you saw--you don't have a subprogram of that
signature. A quick example follows of how you can call PL/SQL:

/tmp>more oaf.sqr
begin-program

  let #x = 2

begin-sql
  begin
    #y := oaf(#x);;
  end;;
end-sql

  show #y
end-program
/tmp>sqr oaf
Enter Username: cats3
Enter Password: 

SQR V4.3.2.2
Copyright (C) SQRIBE Technologies, 1994-98.  All Worldwide Rights
Reserved.

4.000000

SQR: End of Run.
/tmp>


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