Re: Calling PL/SQL functions/procedures in SQR

[Bev Newton <bevhnewton@YAHOO.COM>]

Thanks for your response, Dan.

What I really need to do is return a value from a
PL/SQL function; i.e. I need to return a value from a
freight function to the SQR variable.

Example:

#freight_charge = get_freight(pick_slip_number);

How can I do that?

--- "Johnson, Dan" <Dan_Johnson@WRIGHTEXPRESS.COM>
wrote:
> Try
>
> begin-procedure some_procedure
> begin-sql
> begin
>         some_plsql_proc($param1,#param2.....);;
> end;;
> end-sql
> end-procedure
>
> Dan
>
> -----Original Message-----
> From: Bev Newton
> Sent: Thursday, September 06, 2001 12:52 PM
> To:
> Subject: Calling PL/SQL functions/procedures in SQR
>
>
> I am new to SQR and am revising an old SQR program.
> I
> have PL/SQL functions and procedures written which I
> could use in my program.
>
> How do I call them?
>
> I don't see a straightforward way of doing that.
>
> Thanks for your help.
>
>
> __________________________________________________
> Do You Yahoo!?
> Get email alerts & NEW webcam video instant
> messaging with Yahoo! Messenger
> http://im.yahoo.com


__________________________________________________
Do You Yahoo!?
Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger
http://im.yahoo.com