Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> problems with stored-procedure (ORACLE 8.1.5)
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 Thu Jun 28 2001 - 07:55:37 CDT