Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help needed

Re: help needed

From: Hakan <heren_at_home.com>
Date: 2000/07/18
Message-ID: <3974A171.9BB9A970@home.com>#1/1

hi,

corrections embedded. it is better/clear if you use an alias like sum_amount,
you need to change it in in the body i.e. iaf_accounting_rec.sum_amount

Hakan

Note: please avoid cross-posting.

motty shuster wrote:
>
> I open a curson from a certain table, and create a record type. After that
> I'm trying to fill the record fields with the data from the cursor and I get
> Error:
> can anyone help me?
>
> The program is with the error is:
>
> SQL> @charge_1
> SQL> set serveroutput on size 100000
> SQL> set term on
> SQL> set echo on
> SQL>
> SQL> CREATE OR REPLACE PROCEDURE charge_oracle_extract
> 2 (v_from_cus IN NUMBER,
> 3 v_to_cus IN NUMBER,
> 4 v_file_name IN VARCHAR2,
> 5 v_status OUT CHAR)
> 6 IS
> 7 CURSOR iaf_accounting_crs IS
> 8 SELECT custnum,
> 9 userid,
> 10 package,
> 11 service,
> 12 activity,
> 13 sum(amount) amount,

Received on Tue Jul 18 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US