Re: [sqr-users] oracle stored procedure

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

ah yes, that worked!  I just needed a "#y :=" ..... before the procedure.  
That's why it was complaining that it couldn't find the procedure, when I 
wanted it to be looking for a function.
Thank you very much.


>From: "George Jansen" <GJANSEN@aflcio.org>
>Reply-To: sqr-users@sqrug.org
>To: <sqr-users@sqrug.org>
>Subject: Re: [sqr-users] oracle stored procedure
>Date: Tue, 28 Oct 2003 08:55:55 -0500
>
>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

_________________________________________________________________
Send instant messages to anyone on your contact list with  MSN Messenger 
6.0.  Try it now FREE!  http://msnmessenger-download.com

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