Re: PL/SQL

SP wrote at 02-Jun-00 20:03:45
 on the subject PL/SQL :
>I have this program body having parameters custid 57, cn Joe and ref Dell.

Maybe I'm wrong, but I think 'ref' is a reserved word in PL/SQL:

>CREATE PROCEDURE /*or function*/newShopper(custid in /*or out*/number,cn in
>/*or out*/varchar2,ref /*or out*/in varachar2)
>as
>begin

If you just want to output the values, you could use dbms_output:

dbms_output.put_line('custid      cn                 ref');
dbms_output.put_line('----------- ------------------
--------------------');
dbms_output.put_line(to_char(custid,'9999999999')||' '||
                     rpad(cn,20)||' '||rpad(reff,20));

>end newshopper2;
>/

Before you call this procedure you have to 'set serveroutput on'.

I hope that is what you want,
Lothar

-- 
Lothar Armbrüster       | lothar.armbruester_at_rheingau.vistec.net
Hauptstr. 26            | lothar.armbruester_at_t-online.de
D-65346 Eltville        |