problems with stored procedure (ORACLE 8.1.5)

[Quoted] Hi Group!

I've got a problem with the following stored-procedure:

procedure getOfferData (acustid in
pik_cse_product_text.cust_id_at_DATENBASELINK%type,

                                       aprojid in
pik_cse_product_text.proj_id_at_DATENBASELINK%type,
                                        ainstid in
pik_cse_product_text.inst_id_at_DATENBASELINK%type,
                                        aproductid in
pik_cse_product_text.product_id_at_DATENBASELINK%type,
                                        acountryid in
pik_cse_product_text.country_id_at_DATENBASeLINK%type,
                                        acustomergroupid in
pik_dci_text_types.customer_group_id%type,
                                        aarticlecursor in out
article_cursor,
                                        aerrornr out number,
                                        aerrormsg out varchar2) is

begin

open aarticlecursor
for select *
from pik_cse_offer_list
where cust_id = acustid
and inst_id = ainstid
and proj_id = aprojid
and product_id = aproductid
and country_id = acountryid
and customer_group_id = acustomergroupid;

exception
 when others then
  aerrornr := sqlcode;
  aerrormsg := substr(sqlerrm, 1, 200);

end;

pik_cse_offer_list --> view --> gets data from an other view

When I execute the stored-procedure, I get the following error-message: ORA-01008: not all variables bound
ORA-02063: preceding line from "Name des Datenbanklinks"

All parameters and the views are correct.

Thanks

André Received on Sun Jul 22 2001 - 08:53:44 CEST